目前,OceanBase 数据库 MySQL 模式下的预留关键如下所示。
A | ||||
ACCESSIBLE | ADD | ALL | ALTER | ANALYZE |
AND | AS | ASC | ASENSITIVE | |
B | ||||
BEFORE | BETWEEN | BIGINT | BINARY | BLOB |
BOTH | BY | |||
C | ||||
CALL | CASCADE | CASE | CHANGE | CHAR |
CHARACTER | CHECK | COLLATE | COLUMN | CONDITION |
CONSTRAINT | CONTINUE | CON | VERT | CREATE |
CROSS | CURRENT_DATE | CURRENT_TIME | CURRENT_TIME | STAMP |
CURRENT_USER | CURSOR | |||
D | ||||
DATABASE | DATABASES | DAY_HOUR | DAY_MICROSECOND | DAY_MINUTE |
DAY_SECOND | DECLARE | DECIMAL | DEFAULT | DELAYED |
DELETE | DESC | DESCRIBE | DETERMINISTIC | DISTINCT |
DISTINCTROW | DIV | DOUBLE | DROP | DUAL |
E | ||||
EACH | ELSE | ELSEIF | ENCLOSED | ESCAPED |
EXISTS | EXIT | EXPLAIN | ||
F | ||||
FETCH | FLOAT | FLOAT4 | FLOAT8 | FOR |
FORCE | FOREIGN | FROM | FULLTEXT | |
G | ||||
GENERATED | GET | GRANT | GROUP | |
H | ||||
HAVING | HIGH_PRIORITY | HOUR_MICROSECOND | HOUR_MINUTE | HOUR_SECOND |
I | ||||
IF | IGNORE | IN | INDEX | INFILE |
INNER | INOUT | INSENSITIVE | INSERT | INT |
INT1 | INT2 | INT3 | INT4 | INT8 |
INTEGER | INTERVAL | INTO | IO_AFTER_GTIDS | IO_BEFORE_GTIDS |
IS | ITERATE | |||
J | ||||
JOIN | ||||
K | ||||
KEY | KEYS | KILL | ||
L | ||||
LEADING | LEAVE | LEFT | LIKE | LIMIT |
LINEAR | LINES | LOAD | LOCALTIME | LOCALTIMESTAMP |
LONG | LONGBLOB | LONGTEXT | LOOP | LOW_PRIORITY |
M | ||||
MASTER_BIND | MASTER_SSL_VERIFY_SERVER_CERT | MATCH | MAXVALUE | MEDIUMBLOB |
MEDIUMINT | MEDIUMTEXT | MIDDLEINT | MINUTE_MICROSECOND | MINUTE_SECOND MOD |
MODIFIES | ||||
N | ||||
NATURAL | NOT | NO_WRITE_TO_BINLOG | ||
O | ||||
ON | OPTIMIZE | OPTION | OPTIONALLY | OR |
ORDER | OUT | OUTER | OUTFILE | |
P | ||||
PARTITION | PRECISION | PRIMARY | PROCEDURE | PURGE |
R | ||||
RANGE | READ | READS | READ_WRITE | REAL |
REFERENCES | REGEXP | RELEASE | RENAME | REPEAT |
REPLACE | REQUIRE | RESIGNAL | RESTRICT | RETURN |
REVOKE | RIGHT | RLIKE | ||
S | ||||
SCHEMA | SCHEMAS | SECOND_MICROSECOND | SELECT | SENSITIVE |
SEPARATOR | SET | SHOW | SIGNAL | SMALLINT |
SPATIAL | SPECIFIC | SQL | SQLEXCEPTION | SQLSTATE |
SQLWARNING | SQL_BIG_RESULT | SQL_CALC_FOUND_ROWS | SQL_SMALL_RESULT | SSL |
STARTING | STORED | STRAIGHT_JOIN | ||
T | ||||
TABLE | TERMINATED | THEN | TINYBLOB | TINYINT |
TINYTEXT | TO | TRAILING | TRIGGER | TABLEGROUP |
U | ||||
UNDO | UNION | UNIQUE | UNLOCK | UNSIGNED |
UPDATE | USAGE | USE | USING | UTC_DATE |
UTC_TIME | UTC_TIMESTAMP | |||
V | ||||
VALUES | VARBINARY | VARCHAR | VARCHARACTER | VARYING |
VIRTUAL | ||||
W | ||||
WHEN | WHERE | WHILE | WITH | WRITE |
X | ||||
XOR | ||||
Y | ||||
YEAR_MONTH | ||||
Z | ||||
ZEROFILL |