Updated on 2022-08-17 GMT+08:00

DML

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.

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 >.