Unsupported DML Statements

Table 1 Syntax restrictions on DML
DML Syntax	Constraint
DELETE statement	PARTITION clauses are not supported.
UPDATE statement	Cross-shard subquery is not supported.
SELECT statement	ORDER BY statement. User-defined sequencing similar to ORDER BY FIELD(id,1,2,3) is not supported. NOTE: When the queried table is a sharded table, you cannot obtain the expected result

Parent topic: DML

Была ли эта статья полезна?