1
00:00:00,180 --> 00:00:00,660
All right.

2
00:00:00,660 --> 00:00:03,780
Let's talk about our different selections We're going to perform.

3
00:00:04,080 --> 00:00:06,040
There's just two of them here, I believe.

4
00:00:06,060 --> 00:00:12,180
The first one is select all the shirts from the entire database, but only print out article and color.

5
00:00:13,110 --> 00:00:15,060
So I'll do these directly in the show.

6
00:00:15,150 --> 00:00:17,280
We'll start with select star from shirts.

7
00:00:17,280 --> 00:00:18,360
That's all of them.

8
00:00:18,480 --> 00:00:20,460
But I don't want everything.

9
00:00:20,460 --> 00:00:20,910
Print it out.

10
00:00:20,910 --> 00:00:23,340
I only want article and color.

11
00:00:23,340 --> 00:00:28,110
So select article, comma, color from shirts.

12
00:00:28,110 --> 00:00:29,040
And there we go.

13
00:00:29,040 --> 00:00:32,580
We see all the articles and colors for all the rows.

14
00:00:32,970 --> 00:00:38,580
And then the second piece, select all the medium shirts and don't print everything out.

15
00:00:38,580 --> 00:00:40,830
Print everything but shirt ID.

16
00:00:41,100 --> 00:00:43,310
So let's start with the where portion.

17
00:00:43,330 --> 00:00:50,640
We'll do a select star from shirts where and then it is size equals medium.

18
00:00:50,640 --> 00:00:52,590
Although I think we called it shirt size.

19
00:00:52,590 --> 00:00:54,270
We'll find out really quickly here.

20
00:00:54,720 --> 00:00:56,430
Unknown column size.

21
00:00:57,000 --> 00:00:59,940
Honestly, shirt size is probably a bad name for that column.

22
00:00:59,940 --> 00:01:00,870
It's kind of obvious.

23
00:01:00,870 --> 00:01:02,520
It's a shirt size most likely.

24
00:01:02,520 --> 00:01:04,260
So why not just call it size?

25
00:01:04,349 --> 00:01:05,250
But there we go.

26
00:01:05,250 --> 00:01:07,170
We match the column name precisely.

27
00:01:07,170 --> 00:01:10,320
And we see we get what, four medium shirts?

28
00:01:10,890 --> 00:01:17,640
But then we need to make sure we're only selecting certain columns, all of the columns except for shirt

29
00:01:17,640 --> 00:01:21,600
ID, so I'm just going to list them out instead of Select Star.

30
00:01:21,630 --> 00:01:24,510
I'm going to select article.

31
00:01:25,720 --> 00:01:29,890
Color shirt size and last worn.

32
00:01:30,610 --> 00:01:32,170
And that should do it.

33
00:01:32,170 --> 00:01:38,350
We get article color, shirt size, last worn, no shirt ID for all the medium shirts.

34
00:01:38,350 --> 00:01:39,400
There's only four of them.

35
00:01:39,760 --> 00:01:40,420
All right.

36
00:01:40,420 --> 00:01:42,520
Next up, we're going to talk about updating.