【转帖】MySQL4升级到MySQL5保留字的变化
2007-09-10 12:30:29 / 个人分类：MySQL
对于MySQL低版本升级到高版本之后，变成高版本的保留字的情况，解决方法是进行转义（加单引号''），如：'return'，这样子就可以了。
1.升级后增加的保留字：
ASENSITIVE
CALL
CONDITION
CONNECTION
CONTINUE
CONVERT
CURRENT_USER
CURSOR
DAY_MICROSECOND
DECLARE
DETERMINISTIC
DUAL
EACH
ELSEIF
EXIT
FETCH
FLOAT4
FLOAT8
GOTO
HOUR_MICROSECOND
INOUT
INSENSITIVE
INT1
INT2
INT3
INT4
INT8
ITERATE
LABEL
LEAVE
LOOP
MINUTE_MICROSECOND
MODIFIES
NO_WRITE_TO_BINLOG
OUT
RAID0
RANGE
READS
RELEASE
REPEAT
RETURN
SCHEMA
SCHEMAS
SECOND_MICROSECOND
SENSITIVE
SEPARATOR
SPECIFIC
SQL
SQLEXCEPTION
SQLSTATE
SQLWARNING
UNDO
UTC_DATE
UTC_TIME
UTC_TIMESTAMP
WHILE
X509
2.升级后删除的保留字：
AUTO_INCREMENT
BDB
BERKELEYDB
BTREE
COLUMNS
ERRORS
FIELDS
FUNCTION
HASH
INNODB
MASTER_SERVER_ID
MRG_MYISAM
PRIVILEGES
RETURNS
RTREE
SOME
SONAME
STRIPED
TABLES
TYPES
USER_RESOURCES
WARNINGS
squirrelme发表在自己blog上的文章 转载请注明 地址：http://blog.csdn.net/squirrelme/archive/2007/06/06/1639966.aspx
1.升级后增加的保留字：
ASENSITIVE
CALL
CONDITION
CONNECTION
CONTINUE
CONVERT
CURRENT_USER
CURSOR
DAY_MICROSECOND
DECLARE
DETERMINISTIC
DUAL
EACH
ELSEIF
EXIT
FETCH
FLOAT4
FLOAT8
GOTO
HOUR_MICROSECOND
INOUT
INSENSITIVE
INT1
INT2
INT3
INT4
INT8
ITERATE
LABEL
LEAVE
LOOP
MINUTE_MICROSECOND
MODIFIES
NO_WRITE_TO_BINLOG
OUT
RAID0
RANGE
READS
RELEASE
REPEAT
RETURN
SCHEMA
SCHEMAS
SECOND_MICROSECOND
SENSITIVE
SEPARATOR
SPECIFIC
SQL
SQLEXCEPTION
SQLSTATE
SQLWARNING
UNDO
UTC_DATE
UTC_TIME
UTC_TIMESTAMP
WHILE
X509
2.升级后删除的保留字：
AUTO_INCREMENT
BDB
BERKELEYDB
BTREE
COLUMNS
ERRORS
FIELDS
FUNCTION
HASH
INNODB
MASTER_SERVER_ID
MRG_MYISAM
PRIVILEGES
RETURNS
RTREE
SOME
SONAME
STRIPED
TABLES
TYPES
USER_RESOURCES
WARNINGS
squirrelme发表在自己blog上的文章 转载请注明 地址：http://blog.csdn.net/squirrelme/archive/2007/06/06/1639966.aspx