1
00:00:00,060 --> 00:00:04,380
In this section, we're going to talk about the basics of crud in MySQL.

2
00:00:04,410 --> 00:00:05,850
Now, CRUD is an acronym.

3
00:00:05,850 --> 00:00:12,630
It stands for Create, Read, update and Delete for operations that we often will do.

4
00:00:12,660 --> 00:00:15,230
We'll perform on different rows of data.

5
00:00:15,240 --> 00:00:17,630
We already know how to create rows of data.

6
00:00:17,640 --> 00:00:20,230
We kind of know how to read them using select.

7
00:00:20,250 --> 00:00:25,440
We're also going to learn a lot more about Select and then we'll talk about how we can update information.

8
00:00:25,440 --> 00:00:28,260
How do we alter a row that already exists?

9
00:00:28,260 --> 00:00:29,760
How do we delete rows?

10
00:00:29,760 --> 00:00:30,710
We don't know how to do that.

11
00:00:30,730 --> 00:00:32,970
We know how to drop an entire table.

12
00:00:32,970 --> 00:00:39,570
We know how to create a table, but we don't know how to do all four operations for individual rows

13
00:00:39,570 --> 00:00:40,910
of data crud.

14
00:00:40,920 --> 00:00:43,950
So crud is an acronym that is not specific to SQL.

15
00:00:43,980 --> 00:00:46,830
We use this term in programming in general.

16
00:00:47,430 --> 00:00:50,640
It's not some incredible important term that you need to know.

17
00:00:50,640 --> 00:00:53,670
But I also haven't just made it up myself, just so you know.

18
00:00:53,670 --> 00:00:55,860
So let's go ahead and recap what we do know.

19
00:00:55,860 --> 00:01:00,710
We can create individual rows using insert into right?

20
00:01:00,720 --> 00:01:07,740
We know how to do insert into the cat's table name and age values, and then we provide a name and an

21
00:01:07,740 --> 00:01:09,120
age in that order.

22
00:01:09,210 --> 00:01:10,260
That is how we insert.

23
00:01:10,260 --> 00:01:11,700
There's nothing fancy about inserting.

24
00:01:11,700 --> 00:01:13,050
There's really not much more to it.

25
00:01:13,080 --> 00:01:17,940
We saw that we could do a multiple insert and have multiple rows that we insert at once, but other

26
00:01:17,940 --> 00:01:23,130
than that, all you need to know is that this order matters name and then age, name and then age.

27
00:01:23,130 --> 00:01:25,830
If you had them reversed, you need to reverse them down here.

28
00:01:26,280 --> 00:01:29,100
Now that's the C part of crud.

29
00:01:29,100 --> 00:01:33,960
But this section is really going to be focused on the read parts, the reading, the updating and the

30
00:01:33,960 --> 00:01:34,710
deleting.

31
00:01:34,710 --> 00:01:36,150
So that's where we're going.

32
00:01:36,150 --> 00:01:41,160
We've got a lot to learn about all of these operations, but we've got to start with just getting some

33
00:01:41,160 --> 00:01:46,590
basic data, getting a clean slate so that me and you are on the same page and we have the same data,

34
00:01:46,590 --> 00:01:49,950
therefore the same results when we run the same operations.

35
00:01:49,950 --> 00:01:51,090
So that's what we'll do next.