---
title: "预留关键字（MySQL 模式） - OceanBase 数据库 V5.0.1 | OceanBase 文档中心"
description: 预留关键字（MySQL 模式） 目前，OceanBase 数据库 MySQL 模式下的预留关键字如下所示。 以下是整理后的表格，保持了原有的内容结构，使其更清晰易读： 字母 A ACCESSIBLE ADD ALL ALTER ANALYZE AND AS ASC ASENSITIVE B BEFORE BETWEE…
---
切换语言

- 中文站 - 简体中文
- International - English
- 日本站 - 日本語

文档反馈![](https://mdn.alipayobjects.com/huamei_22khvb/afts/img/A*P8CuR4UJ_FkAAAAAAAAAAAAADiGDAQ/original) OceanBase 数据库分布式版 - V 5.0.1

# 预留关键字（MySQL 模式）

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

[编辑](https://github.com/oceanbase/oceanbase-doc/edit/V5.0.1/zh-CN/700.reference/500.sql-reference/800.reserved-keyword-of-mysql-mode.md)  

目前，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](https://www.oceanbase.com/docs/common-oceanbase-database-cn-1000000006617793)。

- 查询所有 SQL 保留关键字：

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

  ```
 - 查询所有 PL 保留关键字：

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

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

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

  ```

 上一篇 下一篇 ![有帮助](https://gw.alipayobjects.com/mdn/ob_asset/afts/img/A*y6ocSqN8cqsAAAAAAAAAAAAAARQnAQ)![无帮助](https://gw.alipayobjects.com/mdn/ob_asset/afts/img/A*BG9IQJyLHF8AAAAAAAAAAAAAARQnAQ)![反馈](https://gw.alipayobjects.com/mdn/ob_asset/afts/img/A*eTWdQKCRKHwAAAAAAAAAAAAAARQnAQ)[AI](https://www.oceanbase.com/obi) 咨询热线