Ispirer SQLWays数据库迁移软件
MySQL保留字
这些保留字在MySQL不能用作标识符(表或列的名称等)没有用引号引用(`)。介绍了引用标识符在MySQL 3.23.6版本。您也可以用双引号的标识符(")如果您运行MySQL在 ANSI方式。
当迁移数据库到MySQL,SQLWays自动化地解决MySQL的保留字冲突。SQLWays分隔标识符是保留字在MySQL用单引号。
下面字由MySQL保留的:
表格97。 MySQL保留字
ADD
|
ALL
|
ALTER
|
ANALYZE
|
AND
|
AS
|
ASC
|
AUTO_INCREMENT
|
BDB
|
BERKELEYDB
|
BETWEEN
|
BIGINT
|
BINARY
|
BLOB
|
BOTH
|
BTREE
|
BY
|
CASCADE
|
CASE
|
CHANGE
|
CHAR
|
CHARACTER
|
CHECK
|
COLLATE
|
COLUMN
|
COLUMNS
|
CONSTRAINT
|
CREATE
|
CROSS
|
CURRENT_DATE
|
CURRENT_TIME
|
CURRENT_TIMESTAMP
|
DATABASE
|
DATABASES
|
DAY_HOUR
|
DAY_MINUTE
|
DAY_SECOND
|
DEC
|
DECIMAL
|
DEFAULT
|
DELAYED
|
DELETE
|
DESC
|
DESCRIBE
|
DISTINCT
|
DISTINCTROW
|
DIV
|
DOUBLE
|
DROP
|
ELSE
|
ENCLOSED
|
ERRORS
|
ESCAPED
|
EXISTS
|
EXPLAIN
|
FALSE
|
FIELDS
|
FLOAT
|
FOR
|
FORCE
|
FOREIGN
|
FROM
|
FULLTEXT
|
FUNCTION
|
GEOMETRY
|
GRANT
|
GROUP
|
HASH
|
HAVING
|
HELP
|
HIGH_PRIORITY
|
HOUR_MINUTE
|
HOUR_SECOND
|
IF
|
IGNORE
|
IN
|
INDEX
|
INFILE
|
INNER
|
INNODB
|
INSERT
|
INT
|
INTEGER
|
INTERVAL
|
INTO
|
IS
|
JOIN
|
KEY
|
KEYS
|
KILL
|
LEADING
|
LEFT
|
LIKE
|
LIMIT
|
LINES
|
LOAD
|
LOCALTIME
|
LOCALTIMESTAMP
|
LOCK
|
LONG
|
LONGBLOB
|
LONGTEXT
|
LOW_PRIORITY
|
MASTER_SERVER_ID
|
MATCH
|
MEDIUMBLOB
|
MEDIUMINT
|
MEDIUMTEXT
|
MIDDLEINT
|
MINUTE_SECOND
|
MOD
|
MRG_MYISAM
|
NATURAL
|
NOT
|
NULL
|
NUMERIC
|
ON
|
OPTIMIZE
|
OPTION
|
OPTIONALLY
|
OR
|
ORDER
|
OUTER
|
OUTFILE
|
PRECISION
|
PRIMARY
|
PRIVILEGES
|
PROCEDURE
|
PURGE
|
READ
|
REAL
|
REFERENCES
|
REGEXP
|
RENAME
|
REPLACE
|
REQUIRE
|
RESTRICT
|
RETURNS
|
REVOKE
|
RIGHT
|
RLIKE
|
RTREE
|
SELECT
|
SET
|
SHOW
|
SMALLINT
|
SOME
|
SONAME
|
SPATIAL
|
SQL_BIG_RESULT
|
SQL_CALC_FOUND_ROWS
|
SQL_SMALL_RESULT
|
SSL
|
STARTING
|
STRAIGHT_JOIN
|
STRIPED
|
TABLE
|
TABLES
|
TERMINATED
|
THEN
|
TINYBLOB
|
TINYINT
|
TINYTEXT
|
TO
|
TRAILING
|
TRUE
|
TYPES
|
UNION
|
UNIQUE
|
UNLOCK
|
UNSIGNED
|
UPDATE
|
USAGE
|
USE
|
USER_RESOURCES
|
USING
|
VALUES
|
VARBINARY
|
VARCHAR
|
VARCHARACTER
|
VARYING
|
WARNINGS
|
WHEN
|
WHERE
|
WITH
|
WRITE
|
XOR
|
YEAR_MONTH
|
ZEROFILL
|
这些字由ANSI SQL不允许的,但是由 MySQL允许的如同列或表的名称:
- ACTION
- BIT
- DATE
- ENUM
- NO
- TEXT
- TIME
- TIMESTAMP