MySQL Delete

MySQL Delete

MySQL delete syntax and examples.

MySQL Delete syntax

Delete all records from table:

DELETE FROM table;

Delete single or multiple records from table:

DELETE FROM table WHERE condition;

Table test

IDNAME
1abc
2def
3ghi
4jkl

Delete example

DELETE FROM test WHERE id=3;

SELECT * FROM test;

Query Result

IDNAME
1abc
2def
4jkl