预留关键字（MySQL 模式）

更新时间：2024-07-04 15:22:03

目前，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	CONVERT	CREATE	CROSS
CURRENT_DATE	CURRENT_TIME	CURRENT_TIMESTAMP	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