Description:
Delete rows in the table.
Syntax:
DELETE FROM table_source
[
WHERE search_condition ]
| table_source |
List of tables used in the query (tables separated by comma). |
| search_condition |
Logical expression determining which rows of the source table have to be included into deleting (if WHERE is not stated, then it means all records). |
Example1:
Delete all records from the table data.
DELETE FROM data
Example2:
Delete records that meet the specified condition from the table data. Both notations are equivalent.
DELETE FROM data WHERE value > 20 AND value < 80
DELETE FROM data WHERE value BETWEEN 20 AND 80