you are at Encyclopedia of SQL >> DELETE
DELETE
DELETE FROM deletes specified record from table.
Syntax
DELETE FROM `table_name`
[WHERE `column_name` operator 'value']
Syntax for deleting all records from table
DELETE FROM `table_name`
or
DELETE * FROM `table_name`
No specified condition after WHERE causes deleting of all records.
Excample
Delete records from `people` table with age above 6
| name | surname | age |
|---|
| Paweł | Kowalski | 3 |
| Piotr | Janik | 7 |
| Michał | Nowak | 13 |
| Jan | Kowalski | 30 |
query
DELETE FROM `people`
WHERE `age`>6
result
| name | surname | age |
|---|
| Paweł | Kowalski | 3 |
[ wróć na górę strony ]
