Summary - DELETE

Combine WHERE and safety steps to delete safely.

In this group you learned DELETE basics, conditional delete, delete all and TRUNCATE. Removing data is now easy.

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.

Exercise Summary - DELETE

Delete the row with id=2 from products.

Show example solution

DELETE FROM products
WHERE id = 2