DELETE FROM table_source
[ WHERE search_condition ]
table_source | List of tables used in the query (tables separated by a 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). |
DELETE FROM data
DELETE FROM data WHERE value > 20 AND value < 80
DELETE FROM data WHERE value BETWEEN 20 AND 80