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
Ronnie Sokha
941 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
231,236 PointsYou 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
941 PointsAwesome! Thank you so much for your help!
Ronnie Sokha
941 PointsRonnie Sokha
941 PointsThank 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
231,236 PointsSteven Parker
231,236 PointsFor example, if your INSERT had a VALUES list that included
11as the movie_id, you would just replace the number11with that entire subquery expression.