Reserved keywords (MySQL mode)

2023-07-28 02:55:43  Updated

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

Contact Us