Delete rows in the table.
||List of tables used in the query (tables separated by comma).|
||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 all records from the table data.
DELETE FROM data
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