1
00:00:00,090 --> 00:00:05,000
So we left off by creating a new cat's table and it said Query OC.

2
00:00:05,010 --> 00:00:07,250
But the question is, how do we know that it worked?

3
00:00:07,260 --> 00:00:09,540
How do we know that it did what we wanted it to do?

4
00:00:10,110 --> 00:00:12,000
So there's a couple of options.

5
00:00:12,540 --> 00:00:18,720
The first command I'll show you is pretty straightforward show tables, very similar to show databases.

6
00:00:18,870 --> 00:00:22,620
It just is going to show you the current tables in your database.

7
00:00:22,770 --> 00:00:29,430
So we can try that now in cloud nine, we'll do show tables just like that.

8
00:00:30,000 --> 00:00:31,860
And it tells us tables and cat app.

9
00:00:31,860 --> 00:00:33,660
There is one called Cats.

10
00:00:34,050 --> 00:00:34,950
So that's great.

11
00:00:34,950 --> 00:00:38,420
It tells us that there is a cat table, but that's pretty much it.

12
00:00:38,420 --> 00:00:41,190
It doesn't say anything about the contents of that table.

13
00:00:41,190 --> 00:00:42,840
What are the different columns in it?

14
00:00:43,530 --> 00:00:51,030
Which brings us to our next command, which is again using show show columns from a table name.

15
00:00:51,120 --> 00:00:54,720
So in this case, we would say show columns from cats.

16
00:00:55,230 --> 00:00:56,760
So let's try it out now.

17
00:01:02,560 --> 00:01:07,760
And as you can see, we get some nice little table back here that says we've got two fields.

18
00:01:07,780 --> 00:01:14,050
Name and age name is of our char with 100 limit and age is an integer.

19
00:01:14,230 --> 00:01:16,000
And don't worry about this 11 for now.

20
00:01:16,780 --> 00:01:20,890
Then we've got some other data that we're also not going to worry about because we're going to talk

21
00:01:20,890 --> 00:01:22,750
quite a bit about it in the next section.

22
00:01:22,750 --> 00:01:27,700
But there are some other categories here that we're just going to ignore, but this is what we want.

23
00:01:27,700 --> 00:01:29,440
Name of our char age.

24
00:01:29,440 --> 00:01:30,940
INT Perfect.

25
00:01:31,090 --> 00:01:34,990
One other thing I'll show you is that you can use a shorter version.

26
00:01:35,440 --> 00:01:41,650
Technically, these are slightly, slightly different commands, but used in this context there is no

27
00:01:41,650 --> 00:01:42,340
difference.

28
00:01:42,340 --> 00:01:46,960
So we can use, describe or DSC a table name and that's my preference.

29
00:01:46,960 --> 00:01:48,850
It's shorter, easier to remember.

30
00:01:48,850 --> 00:01:50,380
So let's try that out.

31
00:01:50,980 --> 00:01:53,020
Describe cats.

32
00:01:53,740 --> 00:01:56,350
You can see we get the exact same printout.

33
00:01:56,710 --> 00:02:02,710
So I did say that you could use them differently in a more advanced setting where you can basically

34
00:02:02,860 --> 00:02:05,410
pass in some other things to describe.

35
00:02:05,500 --> 00:02:09,820
So anyways, it doesn't really matter, but I just want you to know they're not exactly identical.

36
00:02:09,820 --> 00:02:14,950
It's not like one is a shortcut for the other, but they do the same thing in this context.

37
00:02:14,950 --> 00:02:15,490
All right.

38
00:02:15,490 --> 00:02:17,560
So this video was pretty quick.

39
00:02:17,560 --> 00:02:23,770
It was just about kind of testing and making sure that when you create a table, it's created accurately

40
00:02:23,770 --> 00:02:29,770
and that you can, one, tell that the table is there using show tables, but more importantly, see

41
00:02:29,770 --> 00:02:32,500
the actual columns in that table using these two commands.