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 Modifying Data with SQL Adding Data to a Database Review and Practice

Ronnie Sokha
Ronnie Sokha
939 Points

"Insert a Review" exercise on SQL Playground - Practice: Adding Data Practice Session

I am trying to add a review for the E.T. the Extra-Terrestrial movie but how do you do so if you do not know the movie_id? Do I enter the SELECT statement inside an INSERT statement to find the ID then INSERT my review for that particular movie_id?

2 Answers

Steven Parker
Steven Parker
218,596 Points

You could either look at the reviews table and see what the assigned ID is, or you could have the DB do it for you by using a subquery in the INSERT statement like this instead of a movie_id value:
ā€ƒ (SELECT id FROM movies WHERE title="E.T. the Extra-Terrestrial").

Ronnie Sokha
Ronnie Sokha
939 Points

Thank you for your help. I may be jumping the gun since I haven't learned subqueries yet. I figure I could just look at the "reviews" table to grab the assigned movie ID, but I was considering a scenario where there's a large list of movie ids so how would I go about finding it. Thanks for providing the subquery route. When you say "using a subquery in the INSERT statement...", how would that look exactly?

Steven Parker
Steven Parker
218,596 Points

For example, if your INSERT had a VALUES list that included 11 as the movie_id, you would just replace the number 11 with that entire subquery expression.

Ronnie Sokha
Ronnie Sokha
939 Points

Awesome! Thank you so much for your help!