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


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
        tbl_name[.*] [, tbl_name[.*]] ...
        FROM table_references
        [WHERE where_condition]
        FROM [schema_name.]tbl_name[.*] [, [schema_name.]tbl_name[.*]] ...
        USING table_references
        [WHERE where_condition]           
  • 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.