Appendix E. MySQL Reserved Words

MySQL is made up of keywordsspecial words used in performing SQL operations. Do not use these keywords when naming databases, tables, columns, and any other database objects. These keywords are considered reserved. This appendix lists all of the MySQL reserved words (as of MySQL 5).

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