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;

DELETE FROM table_name WHERE conditions;

DELETE FROM table_name  
WHERE conditions;

Example: Items table before deletion:

DELETE FROM items

WHERE id = 3;

DELETE FROM items WHERE id = 3;

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: