Welcome to the Treehouse Community

The Treehouse Community is a meeting place for developers, designers, and programmers of all backgrounds and skill levels to get support. Collaborate here on code errors or bugs that you need feedback on, or asking for an extra set of eyes on your latest project. Join thousands of Treehouse students and alumni in the community today. (Note: Only Treehouse students can comment or ask questions, but non-students are welcome to browse our conversations.)

Looking to learn something new?

Treehouse offers a seven day free trial for new students. Get access to thousands of hours of content and a supportive community. Start your free trial today.

Databases

Why 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

Ken Alger
Ken Alger
Treehouse Teacher

Timothy;

Welcome to Treehouse!

Do you have a link to the specific course question?

Hi 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
STAFF
Ken Alger
Treehouse Teacher

Timothy;

It looks like you are missing a comma between INTEGER NULL and ADD. Try that and post back with your results.

Happy coding,
Ken

Thanks Ken, One comma was the problem. Many thanks.

Ken Alger
Ken Alger
Treehouse Teacher

Please it all worked out and yes, commas can be the cause of many programming issues.