DELETE basics

Delete rows with DELETE.

With DELETE FROM you remove rows from a table. WHERE picks which rows to delete.

DELETE FROM products
WHERE id = 1;

This query removes product 1.

Rows are deleted from products. Only the rows where id = 1 holds are affected.

DELETE basics — details

Without WHERE, DELETE removes every row; always give a condition. Deleted data cannot be undone.

Delete the row with id=1 from products.

Show example solution

DELETE FROM products
WHERE id = 1

Delete row

DELETE ____ products
WHERE id = 1;

Show answer

DELETE FROM products
WHERE id = 1;