DELETE vs TRUNCATE

Learn the difference between DELETE and TRUNCATE.

Delete all rows

Without WHERE, DELETE FROM table removes all rows. The table structure stays; only data goes.

DELETE FROM products;

This query removes all rows from products; the table becomes empty.

Rows are deleted from products.

Deleting all rows is risky. A faster alternative is TRUNCATE; but TRUNCATE cannot be rolled back and resets auto-increment ids.

Delete the row with id=5 from products.

Show example solution

DELETE FROM products
WHERE id = 5

Delete all

DELETE ____ products;

Show answer

DELETE FROM products;