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.