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

Databases Modifying Data with SQL Adding Data to a Database Review and Practice

Ronnie Sokha
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
Steven Parker
229,579 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
941 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
229,579 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
941 Points

Awesome! Thank you so much for your help!