DELETE query in MySQL

MySQL DELETE
To eliminate data records from a table, the MySQL DELETE statement is used.

Syntax:

DELETE FROM table_name  
WHERE conditions;   

Example:
Items table before deletion:

DELETE FROM items
WHERE id = 3;

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

Items table after deletion: