This topic describes the reserved words in AnalyticDB for MySQL V3.0.

Important Reserved words are not case-sensitive.
Alphabetical orderReserved word
AALL, ALTER, AND, ANY, ARRAY, AS, and ASC
BBEGIN, BETWEEN, BIGINT, BINARY, BLOB, BOOLEAN, BY, and BYTES
CCASE, CAST, CHAR, CHECK, COLUMN, COMPUTE, CONDITION, CONSTRAINT, CONTINUE, CREATE, CURRENT, and CURSOR
DDATABASE, DATE, DATETIME, DECIMAL, DECLARE, DEFAULT, DELETE, DESC, DESCRIBE, DISTINCT, DIV, DOUBLE, DROP, DUAL, and DUPLICATE
EELSE, ESCAPE, EXCEPT, EXISTS, EXPLAIN, and EXTRACT
FFALSE, FETCH, FLOAT, FOR, FOREIGN, FROM, FULL, and FULLTEXT
GGEO2D, GRANT, GROUP, GROUPING, and GROUP_CONCAT
HHAVING
IIDENTIFIED, IF, IGNORE, IN, INDEX, INNER, INSERT, INT, INTEGER, INTERSECT, INTERVAL, INTO, IS, and ITERATE
JJOIN
KKEY and KILL
LLEAVE, LEFT, LIKE, LIMIT, LOCK, LONGTEXT, and LOOP
MMATCH, MEDIUMINT, MEDIUMTEXT, MERGE, MINUS, and MULTIVALUE
NNATURAL, NOT, and NULL
OON, OPEN, OR, ORDER, OUT, OUTER, OVER, and OVERWRITE
PPRIMARY and PROCEDURE
QNone
RRANGE, REAL, REFERENCES, REPEAT, REPLACE, REVOKE, RIGHT, RLIKE, and ROW
SSELECT, SEPARATOR, SET, SHOW, SMALLINT, SOME, SQLSTATE, STRING, and SYSTEM
TTABLE, TEXT, THEN, TIME, TIMESTAMP, TINYINT, TINYTEXT, TO, TOP, TRIGGER, TRUE, and TRUNCATE
UUNDO, UNION, UNIQUE, UNTIL, UPDATE, USE, and USING
VVALUE, VALUES, VARCHAR, and VIEW
WWHEN, WHERE, WHILE, WITH, and WITHIN
XXOR
YNone
ZNone
__BINARY