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 Creating Tables and Manipulating Data with SQL Inserting, Updating and Deleting Rows

harvey bridges
harvey bridges
7,850 Points
Posted by harvey bridges
harvey bridges
7,850 Points

task 3 of objection broken

Cant seem to get task three to work. Have it set as- update movies set year=1979 where title="alien"; when running it error comes back as cant find the movie alien where the year is 1979. Of course you cant find it i am changing the year.

1 Answer

bothxp
bothxp
16,510 Points
bothxp
bothxp
16,510 Points

Hi,

Task 2 of 3: Update the film 'Alien' to have the year 1979.

UPDATE movies SET year=1979 WHERE title="Alien";

Appears to be working now.