Welcome to the Treehouse Community

Want to collaborate on code errors? Have bugs you need feedback on? Looking for an extra set of eyes on your latest project? Get support with fellow developers, designers, and programmers of all backgrounds and skill levels here with the Treehouse Community! While you're at it, check out some resources Treehouse students have shared here.

Looking to learn something new?

Treehouse offers a seven day free trial for new students. Get access to thousands of hours of content and join thousands of Treehouse students and alumni in the community today.

Start your free trial

Databases Creating and Modifying Database Tables Creating and Modifying Database Tables Creating a Table

Kendell Dancy
Kendell Dancy
15,158 Points
Posted by Kendell Dancy
Kendell Dancy
15,158 Points

What am I doing wrong here?

Challenge Task 1 of 1:

We're starting a rock collectors club! Can you create a 'members' table with the following columns: id, first_name, last_name, and favorite_rock. Also, make sure we only allow unique ids.

CREATE members (
    id PRIMARY KEY, 
    first_name, 
    last_name, 
    favorite_rock
  );
Morgan Welch
Morgan Welch
24,127 Points

The command is

CREATE TABLE <table_name> (
columns...
);

1 Answer

Steven Parker
Steven Parker
229,732 Points
Steven Parker
Steven Parker
229,732 Points

As Morgan pointed out, you're missing the keyword "TABLE". But even after fixing it you may still have trouble.

I've seen four other questions about the same issue in the last day so I suspect something has gone wrong with the validation mechanism.

You might want to report that to the Support folks.

Steven Parker
Steven Parker
229,732 Points
Steven Parker
Steven Parker
229,732 Points

UPDATE — it looks like the bug has been fixed, try it now.