---
title: "预留关键字（MySQL 模式） - OceanBase 数据库 V4.1.0 | OceanBase 文档中心"
description: 预留关键字（MySQL 模式） 目前，OceanBase 数据库 MySQL 模式下的预留关键如下所示。 A ACCESSIBLE ADD ALL ALTER ANALYZE AND AS ASC ASENSITIVE B BEFORE BETWEEN BIGINT BINARY BLOB BOTH BY C CAL…
---
切换语言

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

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

# 预留关键字（MySQL 模式）

更新时间：2024-07-04 14:50:46

[编辑](https://github.com/oceanbase/oceanbase-doc/edit/V4.1.0/zh-CN/700.reference/500.system-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 | 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 |

 上一篇 下一篇 ![有帮助](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) 咨询热线