You can execute DELETE statements to delete the rows that meet the conditions from tables.

Syntax

The following DELETE statements delete the rows that meet the conditions specified by where_condition from the tables specified by tbl_name and return the number of deleted rows. If the statement does not include the WHERE clauses, all data in the specified tables is deleted.

  • Single logical table
    DELETE [LOW_PRIORITY] [QUICK] [IGNORE] FROM [schema_name.]tbl_name
    [WHERE where_condition]
  • Multiple logical tables
    DELETE [LOW_PRIORITY] [QUICK] [IGNORE]
    tbl_name[.*] [, tbl_name[.*]] ...
    FROM table_references
    [WHERE where_condition]

DELETE [LOW_PRIORITY] [QUICK] [IGNORE]
    FROM [schema_name.]tbl_name[.*] [, [schema_name.]tbl_name[.*]] ...
    USING table_references
    [WHERE where_condition]
Note
  • DELETE statements support the following modifiers:
    • LOW_PRIORITY: If you specify LOW_PRIORITY, the DELETE operation is performed after all read operations on the table are performed.
    • IGNORE: If you specify IGNORE, the errors that occur when the specified rows are deleted are ignored.
    • The QUICK modifier is related to the storage engines of MySQL. For more information, see MySQL documentation.
  • Each modifier in DELETE statements is pushed down to ApsaraDB RDS for MySQL and remains unchanged. This process does not affect the modifier operations of PolarDB-X.