Appendix B: Reserved Words

MySQL has a list of reserved words that are used as commands or options and clauses in commands. These words should be avoided when naming columns , tables, or databases within your MySQL server. Table B-1 has been provided as a reference to help avoid such unrecommended usage, as well as provide easy access to these words for syntax verification.

Table B-1: Reserved Words

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