DELETE query in MySQL

by

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