Unsupported DML Statements

**Table 1** Syntax restrictions on DML
DML Syntax	Restriction
DELETE statement	PARTITION clauses are not supported.
UPDATE statement	Cross-shard subquery is not supported. Updating sharding keys is not supported.
SELECT statement	User-defined sequencing similar to ORDER BY FIELD(id,1,2,3) is not supported.

Parent topic:DML

Thank you very much for your feedback. We will continue working to improve the documentation.

The system is busy. Please try again later.