The following keywords are reserved for the MySQL mode of OceanBase Database.
| 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 |