预留关键字（MySQL 模式） - OceanBase 数据库 V5.0.1

预留关键字（MySQL 模式）

更新时间：2026-07-29 10:39:50

目前，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	DECIMAL	DECLARE
	DEFAULT	DELAYED	DELETE	DESC
	DESCRIBE	DETERMINISTIC	DISTINCT	DISTINCTROW
	DIV	DOUBLE	DROP	DUAL
E	EACH	ELSE	ELSEIF	ENCLOSED
	ESCAPED	EXISTS	EXIT	EXPLAIN
F	FALSE	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	MEDIUMBLOB
	MEDIUMINT	MEDIUMTEXT	MIDDLEINT	MINUTE_MICROSECOND
	MINUTE_SECOND	MOD	MODIFIES
N	NATURAL	NOT	NO_WRITE_TO_BINLOG	NULL
	NUMERIC
O	ON	OPTIMIZE	OPTION	OPTIONALLY
	OR	ORDER	OUT	OUTER
	OUTFILE
P	PARTITION	PRECISION	PRIMARY	PROCEDURE
	PURGE
R	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	TABLEGROUP	TERMINATED	THEN
	TINYBLOB	TINYINT	TINYTEXT	TO
	TRAILING	TRIGGER	TRUE
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

查询关键字

您也可以通过查询 V$OB_KEYWORDS 视图获取当前租户的完整关键字列表，包括保留关键字和非保留关键字。有关该视图的详细说明，参见 V$OB_KEYWORDS。

查询所有 SQL 保留关键字：

obclient> SELECT KEYWORD FROM oceanbase.V$OB_KEYWORDS WHERE TYPE = 'SQL' AND RESERVED = 1 ORDER BY KEYWORD;

查询所有 PL 保留关键字：

obclient> SELECT KEYWORD FROM oceanbase.V$OB_KEYWORDS WHERE TYPE = 'PL' AND RESERVED = 1 ORDER BY KEYWORD;

查询某个标识符是否为保留关键字：

obclient> SELECT KEYWORD, TYPE, RESERVED FROM oceanbase.V$OB_KEYWORDS WHERE KEYWORD = 'SELECT';