MySQL – Reserved Words 5.0, 5.1 and 5.5 Compared

[adsense id=”0514458240″ width=”468″ height=”60″]

This is a table of the reserved words used in MySQL versions 5.0, 5.1 and 5.5. This should be used as a first check to see why an application has failed during an upgrade. If a new reserved word is added corresponding to an already existing table column then your application will fail. By providing a list of differences between each of the versions the new reserved words can be quickly and readily identified.

Hover over the icons that have an associated asterisk “*” to read the comments.

Reserved Word MySQL 5.0 MySQL 5.1 MySQL 5.5
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
COLUMNS *
CONDITION
CONNECTION * *
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
DEC
DECIMAL
DECLARE
DEFAULT
DELAYED
DELETE
DESC
DESCRIBE
DETERMINISTIC
DISTINCT
DISTINCTROW
DIV
DOUBLE
DROP
DUAL
E
EACH
ELSE
ELSEIF
ENCLOSED
ESCAPED
EXISTS
EXIT
EXPLAIN
F
FALSE
FETCH
FIELDS *
FLOAT
FLOAT4
FLOAT8
FOR
FORCE
FOREIGN
FROM
FULLTEXT
G
GOTO * *
GENERAL *
GRANT
GROUP
H
HAVING
HIGH_PRIORITY
HOUR_MICROSECOND
HOUR_MINUTE
HOUR_SECOND
I
IF
IGNORE
IGNORE_SERVER_IDS
IN
INDEX
INFILE
INNER
INOUT
INSENSITIVE
INSERT
INT
INT1
INT2
INT3
INT4
INT8
INTEGER
INTERVAL
INTO
IS
ITERATE
J
JOIN
K
KEY
KEYS
KILL
L
LABEL * *
LEADING
LEAVE
LEFT
LIKE
LIMIT
LINEAR
LINES
LOAD
LOCALTIME
LOCALTIMESTAMP
LOCK
LONG
LONGBLOB
LONGTEXT
LOOP
LOW_PRIORITY
M
MASTER_HEARTBEAT_PERIOD
MASTER_SSL_VERIFY_SERVER_CERT *
MATCH
MAXVALUE
MEDIUMBLOB
MEDIUMINT
MEDIUMTEXT
MIDDLEINT
MINUTE_MICROSECOND
MINUTE_SECOND
MOD
MODIFIES
N
NATURAL
NO_WRITE_TO_BINLOG
NOT
NULL
NUMERIC
O
ON
OPTIMIZE
OPTION
OPTIONALLY
OR
ORDER
OUT
OUTER
OUTFILE
P
PRECISION
PRIMARY
PRIVILEGES *
PROCEDURE
PURGE
R
RANGE
READ
READ_ONLY *
READ_WRITE *
READS
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
SLOW *
SMALLINT
SONAME
SPATIAL
SPECIFIC
SQL
SQL_BIG_RESULT
SQL_CALC_FOUND_ROWS
SQL_SMALL_RESULT
SQLEXCEPTION
SQLSTATE
SQLWARNING
SSL
STARTING
STRAIGHT_JOIN
T
TABLE
TABLES *
TERMINATED
THEN
TINYBLOB
TINYINT
TINYTEXT
TO
TRAILING
TRIGGER
TRUE
U
UNDO
UNION
UNIQUE
UNLOCK
UNSIGNED
UPDATE
UPGRADE * *
USAGE
USE
USING
UTC_DATE
UTC_TIME
UTC_TIMESTAMP
V
VALUES
VARBINARY
VARCHAR
VARCHARACTER
VARYING
W
WHEN
WHERE
WHILE
WITH
WRITE
X
XOR
Y
YEAR_MONTH
Z
ZEROFILL

[adsense id=”0514458240″ width=”468″ height=”60″]