This topic describes the reserved words in AnalyticDB for MySQL V3.0.
Important Reserved words are not case-sensitive.
Alphabetical order | Reserved word |
---|---|
A | ALL, ALTER, AND, ANY, ARRAY, AS, and ASC |
B | BEGIN, BETWEEN, BIGINT, BINARY, BLOB, BOOLEAN, BY, and BYTES |
C | CASE, CAST, CHAR, CHECK, COLUMN, COMPUTE, CONDITION, CONSTRAINT, CONTINUE, CREATE, CURRENT, and CURSOR |
D | DATABASE, DATE, DATETIME, DECIMAL, DECLARE, DEFAULT, DELETE, DESC, DESCRIBE, DISTINCT, DIV, DOUBLE, DROP, DUAL, and DUPLICATE |
E | ELSE, ESCAPE, EXCEPT, EXISTS, EXPLAIN, and EXTRACT |
F | FALSE, FETCH, FLOAT, FOR, FOREIGN, FROM, FULL, and FULLTEXT |
G | GEO2D, GRANT, GROUP, GROUPING, and GROUP_CONCAT |
H | HAVING |
I | IDENTIFIED, IF, IGNORE, IN, INDEX, INNER, INSERT, INT, INTEGER, INTERSECT, INTERVAL, INTO, IS, and ITERATE |
J | JOIN |
K | KEY and KILL |
L | LEAVE, LEFT, LIKE, LIMIT, LOCK, LONGTEXT, and LOOP |
M | MATCH, MEDIUMINT, MEDIUMTEXT, MERGE, MINUS, and MULTIVALUE |
N | NATURAL, NOT, and NULL |
O | ON, OPEN, OR, ORDER, OUT, OUTER, OVER, and OVERWRITE |
P | PRIMARY and PROCEDURE |
Q | None |
R | RANGE, REAL, REFERENCES, REPEAT, REPLACE, REVOKE, RIGHT, RLIKE, and ROW |
S | SELECT, SEPARATOR, SET, SHOW, SMALLINT, SOME, SQLSTATE, STRING, and SYSTEM |
T | TABLE, TEXT, THEN, TIME, TIMESTAMP, TINYINT, TINYTEXT, TO, TOP, TRIGGER, TRUE, and TRUNCATE |
U | UNDO, UNION, UNIQUE, UNTIL, UPDATE, USE, and USING |
V | VALUE, VALUES, VARCHAR, and VIEW |
W | WHEN, WHERE, WHILE, WITH, and WITHIN |
X | XOR |
Y | None |
Z | None |
_ | _BINARY |