MySQL 中不可使用的保留字有哪些？（mysql的保留字）
MySQL中不可使用的保留字
MySQL是一种关系型数据库管理系统，在MySQL中有些特定的词语被定义为保留字，因此不可以被用于表名、列名、存储过程名等标识符，以下是MySQL中不可使用的保留字：
• ADD
• ALL
• ALTER
• ANALYZE
• AND
• AS
• ASC
• ASENSITIVE
• BEFORE
• BETWEEN
• BIGINT
• BINARY
• BLOB
• BOTH
• BY
• CALL
• CASCADE
• CASE
• CHANGE
• CHAR
• CHARACTER
• CHECK
• COLLATE
• COLUMN
• CONDITION
• CONNECTION
• CONSTRAINT
• CONTINUE
• CONVERT
• CREATE
• CROSS
• CUBE
• CURRENT_DATE
• CURRENT_TIME
• CURRENT_TIMESTAMP
• CURRENT_USER
• CURSOR
• 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
• EACH
• ELSE
• ELSEIF
• ENCLOSED
• ESCAPED
• EXISTS
• EXIT
• EXPLAIN
• FALSE
• FETCH
• FLOAT
• FLOAT4
• FLOAT8
• FOR
• FORCE
• FOREIGN
• FROM
• FULLTEXT
• GET
• GRANT
• GROUP
• HAVING
• HIGH_PRIORITY
• HOUR_MICROSECOND
• HOUR_MINUTE
• HOUR_SECOND
• IF
• IGNORE
• IN
• INDEX
• INFILE
• INNER
• INOUT
• INSENSITIVE
• INSERT
• INT
• INT1
• INT2
• INT3
• INT4
• INT8
• INTEGER
• INTERVAL
• INTO
• IS
• ITERATE
• JOIN
• KEY
• KEYS
• KILL
• LEADING
• LEAVE
• LEFT
• LIKE
• LIMIT
• LINES
• LOAD
• LOCALTIME
• LOCALTIMESTAMP
• LOCK
• LONG
• LONGBLOB
• LONGTEXT
• LOOP
• LOW_PRIORITY
• MATCH
• MEDIUMBLOB
• MEDIUMINT
• MEDIUMTEXT
• MIDDLEINT
• MINUTE_MICROSECOND
• MINUTE_SECOND
• MOD
• MODIFIES
• NATURAL
• NOT
• NO_WRITE_TO_BINLOG
• NULL
• NUMERIC
• ON
• OPTIMIZE
• OPTION
• OPTIONALLY
• OR
• ORDER
• OUT
• OUTER
• OUTFILE
• PRECISION
• PRIMARY
• PROCEDURE
• PURGE
• READ
• READS
• REAL
• REFERENCES
• RELEASE
• RENAME
• REPEAT
• REPLACE
• REQUIRE
• RESTRICT
• RETURN
• REVOKE
• RIGHT
• RLIKE
• SCHEMA
• SCHEMAS
• SECOND_MICROSECOND
• SELECT
• SENSITIVE
• SEPARATOR
• SET
• SHOW
• SMALLINT
• SONAME
• SPATIAL
• SPECIFIC
• SQL
• SQLEXCEPTION
• SQLSTATE
• SQLWARNING
• SQL_BIG_RESULT
• SQL_CALC_FOUND_ROWS
• SQL_SMALL_RESULT
• SSL
• STARTING
• STRAIGHT_JOIN
• TABLE
• TERMINATED
• THEN
• TINYBLOB
• TINYINT
• TINYTEXT
• TO
• TRAILING
• TRIGGER
• TRUE
• UNDO
• UNION
• UNIQUE
• UNLOCK
• UNSIGNED
• UPDATE
• USAGE
• USE
• USING
• UTC_DATE
• UTC_TIME
• UTC_TIMESTAMP
• VALUES
• VARBINARY
• VARCHAR
• VARCHARACTER
• VARYING
• WHEN
• WHERE
• WHILE
• WITH
• WRITE
• XOR
• YEAR_MONTH
• ZEROFILL
以上就是MySQL中不可使用的保留字，在操作MySQL数据库时要特别注意，一旦使用了MySQL中不可使用的保留字，会造成语法错误，影响数据库的正常使用。
