Conditional DELETE

Make DELETE conditional with WHERE.

Delete with WHERE

With WHERE you can delete many rows matching a condition. Write the condition carefully.

DELETE FROM products
WHERE stock = 0;

This query removes all out-of-stock products.

Rows are deleted from products. Only the rows where stock = 0 holds are affected.

WHERE can delete many rows. A wrong condition causes unwanted loss; check with SELECT first.

Delete from products where stock is 0.

Show example solution

DELETE FROM products
WHERE stock = 0

Conditional delete

DELETE FROM products
WHERE ____;

Show answer

DELETE FROM products
WHERE stock = 0;