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中不可使用的保留字，会造成语法错误，影响数据库的正常使用。