1
00:00:00,150 --> 00:00:00,690
All right.

2
00:00:00,690 --> 00:00:05,700
So it's now your turn to give this a try and get some practice using the insert command.

3
00:00:06,300 --> 00:00:08,670
So we'll be working with people this time.

4
00:00:09,120 --> 00:00:11,490
You're going to create a new pupil table.

5
00:00:11,520 --> 00:00:16,740
So actually this is going to combine both creating tables and inserting data.

6
00:00:16,860 --> 00:00:22,860
So the table you'll need to define will have three columns, first name that has a 20 character limit,

7
00:00:22,890 --> 00:00:27,420
last name also has a 20 character limit and age, which is a number.

8
00:00:27,660 --> 00:00:32,910
So once you've defined that table, the next step is to insert your first person.

9
00:00:33,210 --> 00:00:39,510
And for this person, her first name is Tina, her last name is Belcher and her age is 13.

10
00:00:40,170 --> 00:00:44,220
So once you've inserted her, make sure that you've done it correctly.

11
00:00:44,250 --> 00:00:47,040
Use that Select Command to see what's happening.

12
00:00:47,040 --> 00:00:48,120
Make sure she's in there.

13
00:00:48,750 --> 00:00:52,590
The next person will be Bob Belcher, who is 42.

14
00:00:52,950 --> 00:00:59,640
And it's up to you, but I would like for you to try and insert this one using a different order for

15
00:00:59,640 --> 00:01:00,390
the values.

16
00:01:00,390 --> 00:01:05,760
So if you had said first name, comma, last name, comma, age and the previous one, maybe try last

17
00:01:05,760 --> 00:01:10,560
name, comma, age, comma, first name doesn't make a lot of sense to do it that way, but give it

18
00:01:10,560 --> 00:01:14,010
a shot just to prove that you understand that the order matters.

19
00:01:14,580 --> 00:01:22,650
And then lastly, write one insert that will insert three different people at once, and that will be

20
00:01:22,650 --> 00:01:28,620
Linda Belcher, who's 45, Phillip Frond, who is 38, and Calvin Fish Yoder, who is 70.

21
00:01:28,620 --> 00:01:32,910
So insert all three of those at once and go ahead and give it a shot.

22
00:01:32,910 --> 00:01:35,340
And in the next video we'll have a solution.

