You can execute UPDATE statements to modify the rows that meet the conditions in tables.


  • Single logical table
    UPDATE [LOW_PRIORITY] [IGNORE] [schema_name.]tbl_name
        SET assignment_list
        [WHERE where_condition]
        {expr | DEFAULT}
        col_name = value
        assignment [, assignment] ...
  • Multiple logical tables
    UPDATE [LOW_PRIORITY] [IGNORE] table_references
        SET assignment_list
        [WHERE where_condition]         
  • UPDATE statements support the following modifiers:
    • LOW_PRIORITY: If you specify LOW_PRIORITY, the UPDATE operation is performed after all read operations on the table are performed.
    • IGNORE: If you specify IGNORE, the errors are ignored when rows are updated. This indicates that the update is not interrupted by the errors.
  • Each modifier in UPDATE statements is pushed down to ApsaraDB RDS for MySQL and remains unchanged. This process does not affect the modifier operations of PolarDB-X.

Limits on syntax

Compared with the UPDATE syntax of the native MySQL, the UPDATE syntax of PolarDB-X has the following limits:

Correlated and uncorrelated subqueries are not supported in SET clauses. This following code block provides an example on correlated subqueries in SET clauses.
UPDATE t1 SET name = (SELECT name FROM t2 WHERE = WHERE id > 10;
Note The shard key of t1 and t2 is ID.


UPDATE statements for the native MySQL