Preview
Video Player
00:00
00:00
Review and Practice
0:57Let's review deleting rows in different ways and practice the different techniques.
You now know all CRUD operations, create,
read, update, and delete, awesome.
0:00
To recap, to remove onrows from the table,
you can write DELETE FROM <table>.
0:07
This removes every single entry
in the table you specify.
0:14
To remove only the rows that
match a particular condition,
0:18
you can use a where clause
with any number of conditions.
0:22
Any rows matching the condition
will be permanently removed.
0:27
Once again, to practice deleting rows
0:32
I've created a SQL playground with
some more tasks for you to complete.
0:35
Familiarize yourself with the schema and
the data and then complete the tasks.
0:39
You're finished with the main operations
that CRUD has to offer, well done.
0:45
In our final section, we're going to look
into handling multiple CRUD operations and
0:49
dealing with errors that
you could encounter.
0:54