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
| ID | NAME |
|---|---|
| 1 | abc |
| 2 | def |
| 3 | ghi |
| 4 | jkl |
Delete example
DELETE FROM test WHERE id=3; SELECT * FROM test;
Query Result
| ID | NAME |
|---|---|
| 1 | abc |
| 2 | def |
| 4 | jkl |