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

2.1. Reserved Words in MySQL 5.0

The following table shows the reserved words in MySQL 5.0.

ADD ALL ALTER
ANALYZE AND AS
ASC ASENSITIVE BEFORE
BETWEEN BIGINT BINARY
BLOB BOTH BY
CALL CASCADE CASE
CHANGE CHAR CHARACTER
CHECK COLLATE COLUMN
COLUMNS[a] 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 FIELDS[c]
FLOAT FLOAT4 FLOAT8
FOR FORCE FOREIGN
FROM FULLTEXT GOTO[d]
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[e] LEADING
LEAVE LEFT LIKE
LIMIT LINES LOAD
LOCALTIME LOCALTIMESTAMP LOCK
LONG LONGBLOB LONGTEXT
LOOP LOW_PRIORITY 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
PRIVILEGES[f] PROCEDURE PURGE
READ READS REAL
REFERENCES REGEXP RELEASE[g]
RENAME REPEAT REPLACE
REQUIRE RESTRICT RETURN
REVOKE RIGHT RLIKE
SCHEMA SCHEMAS SECOND_MICROSECOND
SELECT SENSITIVE SEPARATOR
SET SHOW SMALLINT
SONAME SPATIAL SPECIFIC
SQL SQLEXCEPTION SQLSTATE
SQLWARNING SQL_BIG_RESULT SQL_CALC_FOUND_ROWS
SQL_SMALL_RESULT SSL STARTING
STRAIGHT_JOIN TABLE TABLES[h]
TERMINATED THEN TINYBLOB
TINYINT TINYTEXT TO
TRAILING TRIGGER TRUE
UNDO UNION UNIQUE
UNLOCK UNSIGNED UPDATE
UPGRADE[i] USAGE USE
USING UTC_DATE UTC_TIME
UTC_TIMESTAMP VALUES VARBINARY
VARCHAR VARCHARACTER VARYING
WHEN WHERE WHILE
WITH WRITE XOR
YEAR_MONTH ZEROFILL  

[a] COLUMNS not reserved in: 5.0.90, 5.0.3-5.0.90

[b] CONNECTION not reserved in: 5.0.90, 5.0.38-5.0.90

[c] FIELDS not reserved in: 5.0.90, 5.0.3-5.0.90

[d] GOTO not reserved in: 5.0.90, 5.0.21-5.0.90

[e] LABEL not reserved in: 5.0.2-5.0.6, 5.0.21-5.0.90

[f] PRIVILEGES not reserved in: 5.0.90, 5.0.3-5.0.90

[g] RELEASE not reserved in: 5.0.2

[h] TABLES not reserved in: 5.0.90, 5.0.3-5.0.90

[i] UPGRADE not reserved in: 5.0.2-5.0.18, 5.0.26-5.0.90