Review and Practice0:57 with Andrew Chalkley
Let'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
You need to sign up for Treehouse in order to download course files.Sign up