1
00:00:00,550 --> 00:00:04,190
Great, you can now insert
data into a database table.

2
00:00:04,190 --> 00:00:07,140
Let's quickly review the ways
you've seen it done.

3
00:00:07,140 --> 00:00:12,470
To create a row use the INSERT INTO
keywords, followed by the table name,

4
00:00:12,470 --> 00:00:17,140
followed by the VALUES keyword,
then the values in parentheses.

5
00:00:17,140 --> 00:00:20,840
This is good if you want to
insert data into all columns.

6
00:00:20,840 --> 00:00:25,660
Remember you can use NULL in your ID
column to trigger the auto increment.

7
00:00:25,660 --> 00:00:31,140
Alternatively, if you're not filling in
all of the columns with your own values,

8
00:00:31,140 --> 00:00:36,200
specify a set of column names between
the table name and the values keyword.

9
00:00:36,200 --> 00:00:39,720
The ordering of the columns and
the values must match.

10
00:00:39,720 --> 00:00:44,060
Finally, if you want to add in
multiple rows in the same statement,

11
00:00:44,060 --> 00:00:47,530
separate each row's set
of values with a comma.

12
00:00:47,530 --> 00:00:52,310
Like with all SQL statements,
this statement can be multi line too.

13
00:00:52,310 --> 00:00:56,630
Now it's your time for you to practice
a little more in this SQL playground.

14
00:00:56,630 --> 00:01:04,180
In here, we've got a movies table,
an actors table, and a reviews table.

15
00:01:05,850 --> 00:01:09,350
I've tasked you to insert some
more data into these tables.

16
00:01:11,140 --> 00:01:14,140
Check out the comments in each area for
what you need to do.

17
00:01:14,140 --> 00:01:15,920
What are you waiting for?

18
00:01:15,920 --> 00:01:16,650
Get to it.

19
00:01:16,650 --> 00:01:20,050
Once you're done practicing,
head over to the next assessment step and

20
00:01:20,050 --> 00:01:20,900
we'll take it from there.