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

Development Tools Database Foundations Joining Relational Data Between Tables in SQL Keys and Auto-Incrementing Values

Henry Fleisher
Henry Fleisher
460 Points
Posted by Henry Fleisher
Henry Fleisher
460 Points

Why Is PRIMARY KEY pk_id missing?

CREATE TABLE t_genres (pk_id INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY, uk_name NOT NULL, VARCHAR(45));

Why is this code wrong?

faranaway
faranaway
Courses Plus Student 13,885 Points
faranaway
faranaway
Courses Plus Student 13,885 Points

Hello!

Looking at your sql I see that you're putting NOT NULL right before setting the datatype.

Your answer: 

CREATE TABLE t_genres (pk_id INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY, uk_name NOT NULL, VARCHAR(45));

Correct

CREATE TABLE t_genres (pk_id INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY, uk_name VARCHAR(45) NOT NULL UNIQUE KEY);