DML

**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.
System database query	The following system database queries are supported: SELECT version() information_schema.SCHEMA_PRIVILEGES information_schema.TABLE_PRIVILEGES information_schema.USER_PRIVILEGES information_schema.SCHEMATA information_schema.tables information_schema.columns SHOW KEYS FROM `table ` FROM `database NOTE: Supported operators include =, IN, and LIKE. These operators can be associated using AND. Complex queries such as subquery, JOIN, sorting, aggregate query, and LIMIT are not supported. information_schema.tables and information_schema.columns support operators < and >.