DELETE

DELETE

The DELETE syntax can be any of the following:

DELETE [LOW_PRIORITY | QUICK] FROM table_name [WHERE    where_clause] [ORDER BY ...] [LIMIT rows] DELETE [LOW_PRIORITY | QUICK] table_name[.*]    [,table_name[.*] ...] FROM table-references [WHERE where_clause] DELETE [LOW_PRIORITY | QUICK] FROM table[.*], [table[.*]    ...] USING table-references [WHERE where_clause]

The DELETE statement deletes records from the table (or tables) that adhere to the where_ clause (or all records if there is no clause).

The LOW PRIORITY keyword causes the DELETE to wait until no other clients are reading the table before processing it.

The QUICK keyword causes MySQL not to merge index leaves during the DELETE, which is sometimes quicker.

LIMIT determines the maximum number of records to be deleted.

The ORDER BY clause causes MySQL to remove records in a certain order (which is useful with a LIMIT clause).