| LOW_PRIORITY | If LOW_PRIORITY is provided, the delete will be delayed until there are no processes reading from the table |
| IGNORE | If 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. |
