1
00:00:00,090 --> 00:00:00,600
All right.

2
00:00:00,600 --> 00:00:04,530
So we have allegedly inserted at least two rows into our cat's table.

3
00:00:04,560 --> 00:00:07,740
How do we know that we actually have those values in there?

4
00:00:07,800 --> 00:00:09,060
Did something go wrong?

5
00:00:09,540 --> 00:00:14,070
Did we accidentally insert name into the age column and age into the name column?

6
00:00:14,100 --> 00:00:16,740
How do we verify that it worked as we want it to?

7
00:00:17,040 --> 00:00:23,250
Well, one of the problems with a lot of programming from a teaching perspective is that there's no

8
00:00:23,250 --> 00:00:25,170
obvious order to teach things in.

9
00:00:25,200 --> 00:00:26,650
Things are very interconnected.

10
00:00:26,670 --> 00:00:30,900
I'm teaching you how to insert in this section, but we have to be able to know if our inserts work.

11
00:00:31,110 --> 00:00:35,910
So I have to show you a command from the next section, which is all about select.

12
00:00:35,910 --> 00:00:38,580
So the next section we'll dive a lot more into select.

13
00:00:38,580 --> 00:00:46,320
But for now, this is the basic most basic usage of select select star from some table name in our case,

14
00:00:46,320 --> 00:00:47,090
cats.

15
00:00:47,100 --> 00:00:48,690
This just tells SQL.

16
00:00:48,720 --> 00:00:52,620
Give me everything you have in the cat's table, so let's try it.

17
00:00:53,130 --> 00:00:58,260
Select star from Cats and we see two cats.

18
00:00:58,260 --> 00:01:00,620
So we have name and age.

19
00:01:00,630 --> 00:01:02,430
They're properly set up, right?

20
00:01:02,430 --> 00:01:08,250
So the ages are inserted in age, the names are inserted into name, it's not reversed or anything and

21
00:01:08,250 --> 00:01:09,810
we have to it's looking good.

22
00:01:10,290 --> 00:01:12,750
So of course we can do the same thing.

23
00:01:12,750 --> 00:01:14,370
Let's do it in the SQL workbench.

24
00:01:14,370 --> 00:01:21,630
This time, if I do select star from Cats, this is commented out, so it looks like I can even just

25
00:01:21,630 --> 00:01:22,020
delete it.

26
00:01:22,020 --> 00:01:24,720
But if I run this here, click the lightning bolt.

27
00:01:24,720 --> 00:01:26,340
We see the same values.

28
00:01:26,340 --> 00:01:30,210
It's a little different looking than it is over here, but it's the same thing, right?

29
00:01:30,210 --> 00:01:32,670
Blue Steel five, Jenkins seven.

30
00:01:33,180 --> 00:01:35,910
Okay, so that's all you need to know about select four now.

31
00:01:35,910 --> 00:01:40,650
But there's a lot more that we will learn and we'll write some very complicated selects later on.

32
00:01:40,650 --> 00:01:44,280
But again, this just says, Give me everything from the cat's table.