LOW_PRIORITY is provided, the delete will be delayed until there are no processes reading from the table
IGNORE is provided, all errors encountered during the delete are ignored
|table||The table from which you are going to delete records|
|WHERE conditions||The conditions that must be met for the records to be deleted. If no conditions are provided, then all records from the table will be deleted|
|ORDER BY expression||If |
ORDER BY is provided, records will be deleted in the given order
|LIMIT||It controls the maximum number of records to delete from the table. Given |
number_rows will be deleted.