1
00:00:00,090 --> 00:00:04,920
So as I just mentioned in the previous video, in order for us to all be on the same page and get the

2
00:00:04,920 --> 00:00:10,110
same results, we kind of need to drop everything and start over with a new table.

3
00:00:10,350 --> 00:00:12,010
So it's going to be a very simple table.

4
00:00:12,030 --> 00:00:14,070
I'm just going to give you a couple of lines of code.

5
00:00:14,070 --> 00:00:17,010
You either type yourself or copy and paste them.

6
00:00:17,010 --> 00:00:23,250
That way we'll all have the same results when we select things or when we update things or delete things.

7
00:00:23,370 --> 00:00:25,740
So we're going to drop our catch table.

8
00:00:26,100 --> 00:00:31,500
I have, I think, a lot of tables called cats something.

9
00:00:31,500 --> 00:00:32,820
Let's look at our tables.

10
00:00:32,820 --> 00:00:35,460
Yeah, cats, cats, two cats, three cats, four.

11
00:00:35,730 --> 00:00:36,870
There's a lot of cats here.

12
00:00:36,870 --> 00:00:39,180
Let's plus all the unique cats.

13
00:00:39,180 --> 00:00:45,660
Anyway, let's just drop table cats, plain old cats, and then we're going to recreate it.

14
00:00:45,900 --> 00:00:51,090
Now, I recommend that you just copy this and paste it or it's not too bad.

15
00:00:51,090 --> 00:00:52,170
You could type it out.

16
00:00:52,200 --> 00:00:58,920
Just make sure we have name, breed and age and some ID that's going to auto increment and I'll copy

17
00:00:58,920 --> 00:01:00,360
and paste that over here.

18
00:01:00,360 --> 00:01:04,709
Hit enter Describe table cats or just describe cats.

19
00:01:04,980 --> 00:01:05,910
Looks good.

20
00:01:06,480 --> 00:01:10,740
And then the most important part is to insert all of these rows.

21
00:01:10,740 --> 00:01:15,990
So it's what, 7 to 8 rows that I'm providing just some basic cats that have a name, a breed and an

22
00:01:15,990 --> 00:01:16,530
age.

23
00:01:16,620 --> 00:01:21,870
But this will allow us to have some data in common that we can work with and get the same results with,

24
00:01:21,870 --> 00:01:22,620
hopefully.

25
00:01:22,620 --> 00:01:27,090
So I did a bulk insert there and let's just use what we know so far.

26
00:01:27,090 --> 00:01:28,710
Select Star from Cats.

27
00:01:28,920 --> 00:01:30,720
We should see seven cats.

28
00:01:30,720 --> 00:01:35,130
They all have a cat ID and then they all have a name, breed and age.

29
00:01:35,370 --> 00:01:37,020
So hopefully you did that.

30
00:01:37,290 --> 00:01:42,240
You can find this code in the slides, but you can also find it just following this video as a resource.

31
00:01:42,570 --> 00:01:46,050
So either way, copy and paste it or if you're adventurous, type it yourself.

32
00:01:46,050 --> 00:01:50,490
In the next video, we're going to talk about the are of crud, which is reading.