Currently, the reserved keywords in the MySQL-compatible mode of OceanBase Database are as follows.
The following table is a summary of the reserved keywords in the MySQL-compatible mode of OceanBase Database. It retains the original content structure for clarity and readability:
Letter |
||||
|---|---|---|---|---|
| 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 |
Query keywords
You can also query the V$OB_KEYWORDS view for a complete list of keywords, including reserved and non-reserved ones, for the current tenant. For more information about this view, see V$OB_KEYWORDS.
Query all SQL reserved keywords:
obclient> SELECT KEYWORD FROM oceanbase.V$OB_KEYWORDS WHERE TYPE = 'SQL' AND RESERVED = 1 ORDER BY KEYWORD;Query all PL reserved keywords:
obclient> SELECT KEYWORD FROM oceanbase.V$OB_KEYWORDS WHERE TYPE = 'PL' AND RESERVED = 1 ORDER BY KEYWORD;Query whether a specific identifier is a reserved keyword:
obclient> SELECT KEYWORD, TYPE, RESERVED FROM oceanbase.V$OB_KEYWORDS WHERE KEYWORD = 'SELECT';