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 Introduction to Data, Databases and SQL Inserting Data

Sharon Eller
Sharon Eller
3,090 Points
Posted by Sharon Eller
Sharon Eller
3,090 Points

In the "movies" table INSERT a new movie with the title "Back to the Future" and year 1985.

Not sure what I'm doing wrong! Any help would be appreciated. Here is my code: INSERT INTO movies TITLE("Back to the Future", 1985);

1 Answer

Erik McClintock
Erik McClintock
45,783 Points
Erik McClintock
Erik McClintock
45,783 Points

Sharon,

You're close! Where you have "TITLE", you actually want to write "VALUES", and then pass the title and year into your values, as follows:

INSERT INTO movies VALUES( 'Back to the Future', 1985 );

Erik

Sharon Eller
Sharon Eller
3,090 Points
Sharon Eller
Sharon Eller
3,090 Points

Thank you, Eric! It worked like a charm.