O AnalyticDB for MySQL V3.0 reserva as seguintes palavras-chave SQL. Se o nome de uma tabela, coluna ou outro identificador corresponder a uma palavra reservada, use crases para evitar erros de análise de SQL.
-- Use a reserved word as a column name
SELECT `value`, `date` FROM orders;As palavras reservadas não diferenciam maiúsculas de minúsculas. SELECT, select e SeLeCt são tratados de forma idêntica.
Palavras reservadas por letra
A tabela a seguir lista todas as palavras reservadas em ordem alfabética.
|
Letra |
Palavras reservadas |
|
A |
ALL, ALTER, AND, ANY, ARRAY, AS, ASC |
|
B |
BEGIN, BETWEEN, BIGINT, BINARY, BLOB, BOOLEAN, BY, BYTES |
|
C |
CASE, CAST, CHAR, CHECK, COLUMN, COMPUTE, CONDITION, CONSTRAINT, CONTINUE, CREATE, CURRENT, CURSOR |
|
D |
DATABASE, DATE, DATETIME, DECIMAL, DECLARE, DEFAULT, DELETE, DESC, DESCRIBE, DISTINCT, DIV, DOUBLE, DROP, DUAL, DUPLICATE |
|
E |
ELSE, ESCAPE, EXCEPT, EXISTS, EXPLAIN, EXTRACT |
|
F |
FALSE, FETCH, FLOAT, FOR, FOREIGN, FROM, FULL, FULLTEXT |
|
G |
GEO2D, GRANT, GROUP, GROUPING, GROUP_CONCAT |
|
H |
HAVING |
|
I |
IDENTIFIED, IF, IGNORE, IN, INDEX, INNER, INSERT, INT, INTEGER, INTERSECT, INTERVAL, INTO, IS, ITERATE |
|
J |
JOIN |
|
K |
KEY, KILL |
|
L |
LEAVE, LEFT, LIKE, LIMIT, LOCK, LONGTEXT, LOOP |
|
M |
MATCH, MEDIUMINT, MEDIUMTEXT, MERGE, MINUS, MULTIVALUE |
|
N |
NATURAL, NOT, NULL |
|
O |
ON, OPEN, OR, ORDER, OUT, OUTER, OVER, OVERWRITE |
|
P |
PRIMARY, PROCEDURE |
|
Q |
Nenhuma |
|
R |
RANGE, REAL, REFERENCES, REPEAT, REPLACE, REVOKE, RIGHT, RLIKE, ROW |
|
S |
SELECT, SEPARATOR, SET, SHOW, SMALLINT, SOME, SQLSTATE, STRING, SYSTEM |
|
T |
TABLE, TEXT, THEN, TIME, TIMESTAMP, TINYINT, TINYTEXT, TO, TOP, TRIGGER, TRUE, TRUNCATE |
|
U |
UNDO, UNION, UNIQUE, UNTIL, UPDATE, USE, USING |
|
V |
VALUE, VALUES, VARCHAR, VIEW |
|
W |
WHEN, WHERE, WHILE, WITH, WITHIN |
|
X |
XOR |
|
Y |
Nenhuma |
|
Z |
Nenhuma |
|
_ |
_BINARY |