Skip navigation links
MySQL Server Version Reference :: 2 Reserved Words :: 2.2 Reserved Words in MySQL 5.1
2.3 Reserved Words in MySQL 5.4 »
Section Navigation      [Toggle]

2.2. Reserved Words in MySQL 5.1

The following table shows the reserved words in MySQL 5.1.

ACCESSIBLE[a] ADD ALL
ALTER ANALYZE AND
AS ASC ASENSITIVE
BEFORE BETWEEN BIGINT
BINARY BLOB BOTH
BY CALL CASCADE
CASE CHANGE CHAR
CHARACTER CHECK COLLATE
COLUMN CONDITION CONNECTION[b]
CONSTRAINT CONTINUE CONVERT
CREATE CROSS CURRENT_DATE
CURRENT_TIME CURRENT_TIMESTAMP CURRENT_USER
CURSOR DATABASE DATABASES
DAY_HOUR DAY_MICROSECOND DAY_MINUTE
DAY_SECOND DEC DECIMAL
DECLARE DEFAULT DELAYED
DELETE DESC DESCRIBE
DETERMINISTIC DISTINCT DISTINCTROW
DIV DOUBLE DROP
DUAL EACH ELSE
ELSEIF ENCLOSED ESCAPED
EXISTS EXIT EXPLAIN
FALSE FETCH FLOAT
FLOAT4 FLOAT8 FOR
FORCE FOREIGN FROM
FULLTEXT GOTO[c] GRANT
GROUP HAVING HIGH_PRIORITY
HOUR_MICROSECOND HOUR_MINUTE HOUR_SECOND
IF IGNORE IN
INDEX INFILE INNER
INOUT INSENSITIVE INSERT
INT INT1 INT2
INT3 INT4 INT8
INTEGER INTERVAL INTO
IS ITERATE JOIN
KEY KEYS KILL
LABEL[d] LEADING LEAVE
LEFT LIKE LIMIT
LINEAR LINES LOAD
LOCALTIME LOCALTIMESTAMP LOCK
LONG LONGBLOB LONGTEXT
LOOP LOW_PRIORITY MASTER_SSL_VERIFY_SERVER_CERT[e]
MATCH MEDIUMBLOB MEDIUMINT
MEDIUMTEXT MIDDLEINT MINUTE_MICROSECOND
MINUTE_SECOND MOD MODIFIES
NATURAL NOT NO_WRITE_TO_BINLOG
NULL NUMERIC ON
OPTIMIZE OPTION OPTIONALLY
OR ORDER OUT
OUTER OUTFILE PRECISION
PRIMARY PROCEDURE PURGE
RANGE READ READS
READ_ONLY[f] READ_WRITE[g] REAL
REFERENCES REGEXP RELEASE
RENAME REPEAT REPLACE
REQUIRE RESTRICT RETURN
REVOKE RIGHT RLIKE
SCHEMA SCHEMAS SECOND_MICROSECOND
SELECT SENSITIVE SEPARATOR
SET SHOW SMALLINT
SPATIAL SPECIFIC SQL
SQLEXCEPTION SQLSTATE SQLWARNING
SQL_BIG_RESULT SQL_CALC_FOUND_ROWS SQL_SMALL_RESULT
SSL STARTING STRAIGHT_JOIN
TABLE TERMINATED THEN
TINYBLOB TINYINT TINYTEXT
TO TRAILING TRIGGER
TRUE UNDO UNION
UNIQUE UNLOCK UNSIGNED
UPDATE UPGRADE[h] USAGE
USE USING UTC_DATE
UTC_TIME UTC_TIMESTAMP VALUES
VARBINARY VARCHAR VARCHARACTER
VARYING WHEN WHERE
WHILE WITH WRITE
XOR YEAR_MONTH ZEROFILL

[a] ACCESSIBLE not reserved in: 5.1.3-5.1.5

[b] CONNECTION not reserved in: 5.1.45, 5.1.16-5.1.45

[c] GOTO not reserved in: 5.1.45, 5.1.11-5.1.45

[d] LABEL not reserved in: 5.1.45, 5.1.11-5.1.45

[e] MASTER_SSL_VERIFY_SERVER_CERT not reserved in: 5.1.3-5.1.17

[f] READ_ONLY not reserved in: 5.1.3-5.1.5, 5.1.24-5.1.45

[g] READ_WRITE not reserved in: 5.1.3-5.1.5

[h] UPGRADE not reserved in: 5.1.3-5.1.6, 5.1.12-5.1.45

The following are new reserved words in MySQL 5.1:

ACCESSIBLE LINEAR MASTER_SSL_VERIFY_SERVER_CERT
RANGE READ_ONLY READ_WRITE