WEBVTT

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.