Hello, in this video we are going to cover the Delete operation, which I'm sure you can guess what it does allow you to delete a row or a selection of rows. So what we're going to do is delete the row which has a name of font, and first create a SQL query. Delete. Table, top left the table name. And now we're going to say where name equals So this is the condition for when the name equals home. Now, do you think you need to run it?
Troy to make sure we can delineate reporting and the main error that we would handle if something goes wrong, that we just rolled back the database, you can obviously print something out here as well. If you want to But the main thing is back cursor dot execute to actually run the query. So this just give the green light to go ahead and run it. And now we just make the changes to the database, save it, run it again, go to database add feed that row has now gone. So that's it for this video on the Delete operation. If you have any more questions, feel free to reach out and I look forward to seeing you in the next video.