Save up to $499! Grab all Python courses for $49 or all online courses we’ve ever launched for only $169. Only Feb 11-16. Happy Valentine's!
Introduction
CTEs with data modifying statements
11. DELETE statement
Summary

Instruction

Great. It’s time for the last data modification statement, DELETE. First we will remember the syntax of the DELETE statement. This statement is used to remove records from a table. Look at the example:

DELETE FROM customer
WHERE id = 15;

This statement starts with a DELETE FROM, after which we give the name of the table. In this case we delete records from our customer table. In the the WHERE clause, we specify records to delete. In this query the condition (id = 15) causes removal of only one record, the one with id equal 15.

Exercise

Remove from the database the store with the name of Small Grocery Store.

Stuck? Here's a hint!

Use DELETE FROM ... WHERE ...