Deleting data
2. Delete all rows

Instruction

Great! Now something a little bit scary. You can delete ALL rows from a table in one command. Just run the DELETE command with no WHERE condition.

DELETE FROM user; 

Caution: be careful using this command in a real database!

Exercise

The owners finally decided on a single cuisine. They want to serve Creole dishes so delete all the data from the table dish to make room for new meals.

Stuck? Here's a hint!

Type

DELETE FROM dish;