1
00:00:00,400 --> 00:00:05,060
You now know all CRUD operations, create,
read, update, and delete, awesome.

2
00:00:07,001 --> 00:00:14,140
To recap, to remove onrows from the table,
you can write DELETE FROM <table>.

3
00:00:14,140 --> 00:00:17,550
This removes every single entry
in the table you specify.

4
00:00:18,770 --> 00:00:22,720
To remove only the rows that
match a particular condition,

5
00:00:22,720 --> 00:00:26,550
you can use a where clause
with any number of conditions.

6
00:00:27,700 --> 00:00:31,210
Any rows matching the condition
will be permanently removed.

7
00:00:32,560 --> 00:00:35,100
Once again, to practice deleting rows

8
00:00:35,100 --> 00:00:39,790
I've created a SQL playground with
some more tasks for you to complete.

9
00:00:39,790 --> 00:00:45,220
Familiarize yourself with the schema and
the data and then complete the tasks.

10
00:00:45,220 --> 00:00:49,740
You're finished with the main operations
that CRUD has to offer, well done.

11
00:00:49,740 --> 00:00:54,510
In our final section, we're going to look
into handling multiple CRUD operations and

12
00:00:54,510 --> 00:00:56,800
dealing with errors that
you could encounter.