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
|The table from which you are going to delete records
|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
ORDER BY is provided, records will be deleted in the given order
|It controls the maximum number of records to delete from the table. Given
number_rows will be deleted.