Safe deletion

Learn ways to avoid accidental deletion.

DELETE vs TRUNCATE

TRUNCATE empties a table quickly. Unlike DELETE it does not go row by row; it drops whole pages at once.

TRUNCATE TABLE products;

This query empties the products table instantly.

TRUNCATE usually cannot be rolled back and resets auto-increment ids. DELETE is slower but can be rolled back inside a transaction.

Delete the row with id=4 from products.

Show example solution

DELETE FROM products
WHERE id = 4

Fast empty

TRUNCATE ____ products;

Show answer

TRUNCATE TABLE products;