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 trialKendell Dancy
15,158 PointsWhat 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
);
1 Answer
Steven Parker
231,184 PointsAs 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
231,184 PointsUPDATE — it looks like the bug has been fixed, try it now.
Morgan Welch
24,127 PointsMorgan Welch
24,127 PointsThe command is