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
Timothy James-Hammond
1,641 PointsWhy does this not work as question 3??? Of the database foundations questions.
I have checked it and checked it and I cant find out why it is not working?
ALTER TABLE t_movies ADD COLUMN fk_genre_id INTEGER NULL ADD CONSTRAINT FOREIGN KEY(fk_genre_id) REFERENCES t_genres(pk_id);
Many thanks
Timothy James-Hammond
1,641 PointsHi its for question. Alter the "t_movies" table to add a foreign key column called "fk_genre_id" and constrain it to reference the "t_genres" "pk_id".
My code is ALTER TABLE t_movies ADD COLUMN fk_genre_id INTEGER NULL ADD CONSTRAINT FOREIGN KEY(fk_genre_id) REFERENCES t_genres(pk_id);
But it does not work.
Any help would be great as I have ground to a halt on this one.
2 Answers
Ken Alger
Treehouse TeacherTimothy;
It looks like you are missing a comma between INTEGER NULL and ADD. Try that and post back with your results.
Happy coding,
Ken
Timothy James-Hammond
1,641 PointsThanks Ken, One comma was the problem. Many thanks.
Ken Alger
Treehouse TeacherPlease it all worked out and yes, commas can be the cause of many programming issues.
Ken Alger
Treehouse TeacherKen Alger
Treehouse TeacherTimothy;
Welcome to Treehouse!
Do you have a link to the specific course question?