Bummer! This is just a preview. You need to be signed in with a Basic account to view the entire video.
Review and Practice1:21 with Andrew Chalkley
In this video we'll review all the ways you can insert data.
Great, you can now insert data into a database table.
Let's quickly review the ways you've seen it done.
To create a row use the INSERT INTO keywords, followed by the table name,
followed by the VALUES keyword, then the values in parentheses.
This is good if you want to insert data into all columns.
Remember you can use NULL in your ID column to trigger the auto increment.
Alternatively, if you're not filling in all of the columns with your own values,
specify a set of column names between the table name and the values keyword.
The ordering of the columns and the values must match.
Finally, if you want to add in multiple rows in the same statement,
separate each row's set of values with a comma.
Like with all SQL statements, this statement can be multi line too.
Now it's your time for you to practice a little more in this SQL playground.
In here, we've got a movies table, an actors table, and a reviews table.
I've tasked you to insert some more data into these tables.
Check out the comments in each area for what you need to do.
What are you waiting for?
Get to it.
Once you're done practicing, head over to the next assessment step and
we'll take it from there.
You need to sign up for Treehouse in order to download course files.Sign up