The DELETE statement removes rows from a table.

Basic Syntax

DELETE FROM table_name
WHERE condition;

• table_name : The table you want to delete rows from.
• WHERE : Specifies which rows to delete.Warning: If omitted, all rows are deleted!

Example 1: Delete a Specific Row

DELETE FROM cats
WHERE cat_id = 2;

Explanation:

Removes the row where cat_id is 2 from the cats table.

Example 2: Delete Multiple Rows

DELETE FROM cats
WHERE age > 10;

Explanation:

Deletes all cats older than 10 years.

Example 3: Delete All Rows

DELETE FROM cats;

Explanation:

Removes all rows from the cats table.

The table structure remains.