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

Posted by David Lopez
David Lopez
3,211 Points

I have encountered an error in the database foundations course and it is not letting me complete and continue an object

I am trying to complete the manipulating schema with sql and it is asking me to complete the ADD COLUMNS objective.

When I enter the SQL code as needed:

ALTER TABLE movies_table ADD COLUMN genre VARCHAR(25);

the system tells me im not using ADD...

tell me how to correct this please so that I can move on...

Dustin Matlock
Dustin Matlock
33,856 Points

Hi Daniel, can you provide the link to the code challenge? Thanks.

3 Answers

Dustin Matlock
Dustin Matlock
33,856 Points

David, you can remove the _table part like this and you should be good.

ALTER TABLE movies ADD COLUMN genre VARCHAR(25);
David Lopez
David Lopez
3,211 Points
David Lopez
David Lopez
3,211 Points

http://teamtreehouse.com/library/database-foundations/manipulating-schema-with-sql/adding-columns

David Lopez
David Lopez
3,211 Points
David Lopez
David Lopez
3,211 Points

thanks man!!!