DELETE query in MySQL

MySQL DELETE: The MySQL DELETE statement is used to eliminate data records from a table.

Syntax:

DELETE FROM table_name  
WHERE conditions;

 

Example: Items table before deletion:

ID	NAME	QUANTITY
1	Electronics	30
2	Sports	45
3	Fashion	100
4	Grocery	90
5	Toys	50

DELETE FROM items
WHERE id = 3;

Explanation: The ‘items’ is an existing table, from which we delete the row where the id is 3.

Items table after deletion:

ID	NAME	QUANTITY
1	Electronics	30
2	Sports	45
4	Grocery	90
5	Toys	50