Help Center/ Distributed Database Middleware/ User Guide (Kuala Lumpur Region)/ SQL Syntax/ DML/ UPDATE
Updated on 2022-08-17 GMT+08:00
View PDF
Share

UPDATE

Common Syntax

UPDATE table_reference
SET col_name1={expr1} [, col_name2={expr2}] ...
[WHERE where_condition]

Syntax Restrictions

  • Subqueries are not supported, including correlated subqueries and non-correlated subqueries.
  • The WHERE condition in the UPDATE statement does not support arithmetic expressions and their subqueries.
  • Modifying reference tables is not supported during update of multiple tables.
  • Updating the sharding key field of a logical table is not supported. Updating the sharding key field may cause data redistribution.
Parent topic: DML