The following reserved keywords are used in OceanBase Database's MySQL mode.
The table below lists these reserved keywords in a structured manner for clarity and readability:
| Letter | ||||
|---|---|---|---|---|
| A | ACCESSIBLE | ADD | ALTER | ANALYZE |
| AS | ASC | ASENSITIVE | ||
| B | BEFORE | BETWEEN | BIGINT | BINARY |
| BLOB | ||||
| 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 | DISTINCTROW | DIV | |
| DOUBLE | DROP | DUAL | ||
| E | EACH | ELSE | ELSEIF | ENCLOSED |
| ESCAPED | EXISTS | EXIT | EXPLAIN | |
| F | FETCH | FLOAT | FLOAT4 | FLOAT8 |
| FOR | FORCE | FOREIGN | 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 | 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 | NUMERIC |
| 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 | SENSITIVE |
| SEPARATOR | SET | SHOW | SIGNAL | |
| SMALLINT | SPATIAL | SPECIFIC | SQL | |
| SQLEXCEPTION | SQLSTATE | SQLWARNING | SQL_BIG_RESULT | |
| SQL_SMALL_RESULT | SSL | SKIP | STARTING | |
| STORED | ||||
| T | TABLE | TERMINATED | THEN | TINYBLOB |
| TINYINT | TINYTEXT | TO | TRIGGER | |
| U | UNDO | UNION | UNLOCK | UNSIGNED |
| UPDATE | USAGE | USE | USING | |
| UTC_DATE | UTC_TIME | UTC_TIMESTAMP | ||
| V | VALUES | VARBINARY | VARCHAR | VARCHARACTER |
| VARYING | VIRTUAL | |||
| W | WHERE | WHILE | WITH | WRITE |
| X | XOR | |||
| Y | YEAR_MONTH | |||
| Z | ZEROFILL |