DELETE
suggest changeSyntax
- DELETE [ LOW_PRIORITY ] [ QUICK ] [ IGNORE ] FROM table [WHERE conditions] [ORDER BY expression [ ASC | DESC ]] [LIMIT number_rows]; /// Syntax for delete row(s) from single table
Parameters
|Parameter |Details | |––––––––––|————————| |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.
Found a mistake? Have a question or improvement idea?
Let me know.
Table Of Contents