以下是MySQL的保留字列表,按字母顺序排列:

A

  • ADD
  • ALL
  • ALTER
  • ANALYZE
  • AND
  • ANY
  • AS
  • ASC
  • ASCII
  • ASENSITIVE
  • AT
  • AUTO_INCREMENT
  • AVG

B

  • BETWEEN
  • BIGINT
  • BINARY
  • BLOB
  • BOTH
  • BY
  • BYTE

C

  • CALL
  • CASCADE
  • CASCIATE
  • CASE
  • CAST
  • CATALOG_NAME
  • CHANGE
  • CHAR
  • CHARACTER
  • CHAR_LENGTH
  • CHARACTER_LENGTH
  • CHECK
  • CHECKSUM
  • CLOB
  • CLOSE
  • COALESCE
  • COLLATE
  • COLLATION
  • COLUMN
  • COLUMNS
  • COLUMN_NAME
  • COMMENT
  • COMMIT
  • COMMITTED
  • COMPRESS
  • COMPRESSED
  • COMPRESSION
  • CONDITION
  • CONNECTION_NAME
  • CONSTRAINT
  • CONSTRAINT_CATALOG
  • CONSTRAINT_NAME
  • CONSTRAINT_SCHEMA
  • CONTAINS
  • CONTINUE
  • CONVERT
  • CPU
  • CREATE
  • CROSS
  • CUBE
  • CURRENT_DATE
  • CURRENT_TIME
  • CURRENT_TIMESTAMP
  • CURRENT_USER
  • CURSOR
  • CURSOR_NAME
  • DATA
  • DATABASE
  • DATABASES
  • DATAFILE
  • DATE
  • DATETIME
  • DAY
  • DAY_HOUR
  • DAY_MICROSECOND
  • DAY_MINUTE
  • DAY_SECOND
  • DEC
  • DECIMAL
  • DECLARE
  • DEFAULT
  • DELAYED
  • DELETE
  • DELIMITER
  • DELIMITERS
  • DENSE_RANK
  • DES_KEY_FILE
  • DESC
  • DESCRIBE
  • DESCRIBES
  • DETERMINISTIC
  • DIRECTORY
  • DISABLE
  • DISCARD
  • DISTINCT
  • DISTINCTROW
  • DIV
  • DO
  • DOUBLE
  • DROP
  • DUAL
  • DUMPFILE
  • DUPLICATE
  • DYNAMIC

E

  • ELSE
  • ELSEIF
  • ENABLE
  • ENCLOSED
  • ENCRYPTION
  • ENDS
  • ENGINE
  • ENUM
  • ESCAPE
  • ESCAPED
  • EXCEPT
  • EXCEPTION
  • EXECUTE
  • EXISTS
  • EXIT
  • EXPANSION
  • EXPLAIN
  • EXPORT
  • EXTENDED
  • EXTENT_SIZE

F

  • FALSE
  • FETCH
  • FILE
  • FIRST
  • FIXED
  • FLOAT
  • FLOAT4
  • FLOAT8
  • FOR
  • FORCE
  • FOREIGN
  • FORMAT
  • FOUND
  • FROM
  • FULL
  • FULLTEXT
  • FUNCTION
  • GENERAL
  • GENERATED
  • GEOMETRY
  • GEOMETRYCOLLECTION
  • GET
  • GET_FORMAT
  • GLOBAL
  • GRANT
  • GRANTS
  • GROUP
  • GROUP BY
  • GROUP_CONCAT
  • GROUPING
  • HANDLER
  • HASH
  • HAVING
  • HELP
  • HIGH_PRIORITY
  • HOUR
  • HOUR_MICROSECOND
  • HOUR_MINUTE
  • HOUR_SECOND
  • IF
  • IGNORE
  • IGNORE_SERVER_IDS
  • IMPORT
  • IN
  • INDEX
  • INDEXES
  • INFILE
  • INNER
  • INOUT
  • INSENSITIVE
  • INSERT
  • INSERT_METHOD
  • INSTALL
  • INSTANCE
  • INT
  • INT1
  • INT2
  • INT3
  • INT4
  • INT8
  • INTEGER
  • INTERVAL
  • INTO
  • IO
  • IO_AFTER_GTIDS
  • IO_BEFORE_GTIDS
  • IO_THREAD
  • IPC
  • IS
  • ISOLATION
  • ITERATE

J

  • JOIN

K

  • KEY
  • KEYS
  • KILL

L

  • LAG
  • LAST_VALUE
  • LEAD
  • LEADING
  • LEAVE
  • LEFT
  • LESS
  • LEVEL
  • LIKE
  • LIMIT
  • LINEAR
  • LINES
  • LINESTRING
  • LIST
  • LOAD
  • LOCAL
  • LOCALTIME
  • LOCALTIMESTAMP
  • LOCK
  • LOCKS
  • LONG
  • LONGBLOB
  • LONGTEXT
  • LOOP
  • LOW_PRIORITY

M

  • MASTER
  • MASTER_AUTO_POSITION
  • MASTER_BIND
  • MASTER_CONNECT_RETRY
  • MASTER_DELAY
  • MASTER_HEARTBEAT_PERIOD
  • MASTER_HOST
  • MASTER_LOG_FILE
  • MASTER_LOG_POS
  • MASTER_PASSWORD
  • MASTER_PORT
  • MASTER_RETRY_COUNT
  • MASTER_SERVER_ID
  • MASTER_SSL
  • MASTER_SSL_CA
  • MASTER_SSL_CAPATH
  • MASTER_SSL_CERT
  • MASTER_SSL_CIPHER
  • MASTER_SSL_CRL
  • MASTER_SSL_CRLPATH
  • MASTER_SSL_KEY
  • MASTER_SSL_VERIFY_SERVER_CERT
  • MASTER_TLS_VERSION
  • MASTER_USER
  • MATCH
  • MAXVALUE
  • MEDIUM
  • MEDIUMBLOB
  • MEDIUMINT
  • MEDIUMTEXT
  • MEMBER OF
  • MEMORY
  • MERGE
  • MESSAGE_TEXT
  • MICROSECOND
  • MIDDLEINT
  • MINUTE
  • MINUTE_MICROSECOND
  • MINUTE_SECOND
  • MOD
  • MODE
  • MODIFIES
  • MODIFY
  • MONTH
  • MULTILINESTRING
  • MULTIPOINT
  • MULTIPOLYGON
  • MUTEX

N

  • NCHAR
  • NCHARACTER
  • NDB
  • NDBCLUSTER
  • NEW
  • NEXT
  • NO
  • NO_WRITE_TO_BINLOG
  • NONE
  • NOT
  • NOW
  • NO_WAIT
  • NULL
  • NULLIF
  • NUMBER
  • NUMERIC

O

  • OF
  • OFFSET
  • OLD
  • ON
  • ONE
  • ONLY
  • OPEN
  • OPTIMIZE
  • OPTIMIZER_COSTS
  • OPTION
  • OPTIONAL
  • OPTIONALLY
  • OR
  • ORDER
  • ORDER BY
  • ORGANIZATION
  • ORPHAN
  • OUT
  • OUTER
  • OUTFILE
  • OWNER

P

  • PACKAGE
  • PAGE
  • PARALLEL
  • PARTIAL
  • PARTITION
  • PARTITION BY
  • PARTITIONING
  • PARTITIONS
  • PASSWORD
  • PHASE
  • PLUGIN
  • PLUGINS
  • PLUGIN_DIR
  • POINT
  • POLYGON
  • PORT
  • PRECISION
  • PREPARE
  • PRESERVE
  • PREV
  • PRIMARY
  • PRINT
  • PRIVILEGES
  • PROCEDURE
  • PROCESSLIST
  • PROFILE
  • PROFILES
  • PROXY
  • PURGE

Q

  • QUARTER
  • QUERY
  • QUICK

R

  • RANGE
  • RANK
  • READ
  • READS
  • READ_WRITE
  • READ_ONLY
  • REAL
  • REBUILD
  • RECOVER
  • RECURSIVE
  • REFERENCE
  • REFERENCES
  • REGEXP
  • REGISTRATION
  • RELAY
  • RELAYLOG
  • RELAYLOGFILE
  • RELAYLOGPOS
  • RELAY_MASTER_LOG_FILE
  • RELEASE
  • RELOAD
  • REMOVE
  • RENAME
  • REORGANIZE
  • REPAIR
  • REPEAT
  • REPEATABLE
  • REPLACE
  • REPLICATE
  • REPLICATION
  • REQUIRE
  • RESET
  • RESIGNAL
  • RESTORE
  • RESTRICT
  • RETURN
  • RETURNS
  • REUSE
  • REVERSE
  • REVOKE
  • RIGHT
  • RLIKE
  • ROLE
  • ROLLBACK
  • ROLLUP
  • ROTATE
  • ROUTINE
  • ROW
  • ROWS
  • ROW_COUNT
  • ROW_FORMAT
  • RTREE

S

  • SAVEPOINT
  • SECOND
  • SECONDARY
  • SECONDARY_ENGINE
  • SECONDARY_LOAD
  • SECONDARY_UNLOAD
  • SECOND_MICROSECOND
  • SECURITY
  • SELECT
  • SENSITIVE
  • SEPARATOR
  • SERIAL
  • SERIALIZABLE
  • SERVER
  • SESSION
  • SET
  • SHARE
  • SHOW
  • SHUTDOWN
  • SIGNAL
  • SIGNED
  • SIMPLE
  • SLAVE
  • SLOW
  • SMALLINT
  • SNAPSHOT
  • SOCKET
  • SOME
  • SONAME
  • SOUNDS
  • SOURCE
  • SOURCE_AUTO_POSITION
  • SOURCE_BIND
  • SOURCE_CONNECT_RETRY
  • SOURCE_DELAY
  • SOURCE_HEARTBEAT_PERIOD
  • SOURCE_HOST
  • SOURCE_LOG_FILE
  • SOURCE_LOG_POS
  • SOURCE_PASSWORD
  • SOURCE_PORT
  • SOURCE_RETRY_COUNT
  • SOURCE_SERVER_ID
  • SOURCE_SSL
  • SOURCE_SSL_CA
  • SOURCE_SSL_CAPATH
  • SOURCE_SSL_CERT
  • SOURCE_SSL_CIPHER
  • SOURCE_SSL_CRL
  • SOURCE_SSL_CRLPATH
  • SOURCE_SSL_KEY
  • SOURCE_SSL_VERIFY_SERVER_CERT
  • SOURCE_TLS_VERSION
  • SOURCE_USER
  • SPATIAL
  • SPECIFIC
  • SQL
  • SQLEXCEPTION
  • SQLSTATE
  • SQLWARNING
  • SQL_BIG_RESULT
  • SQL_BUFFER_RESULT
  • SQL_CACHE
  • SQL_CALC_FOUND_ROWS
  • SQL_NO_CACHE
  • SQL_SMALL_RESULT
  • SQL_THREAD
  • SQL_TSI_DAY
  • SQL_TSI_FRAC_SECOND
  • SQL_TSI_HOUR
  • SQL_TSI_MINUTE
  • SQL_TSI_MONTH
  • SQL_TSI_QUARTER
  • SQL_TSI_SECOND
  • SQL_TSI_WEEK
  • SQL_TSI_YEAR
  • START
  • STARTING
  • STARTS
  • STATS_PERSISTENT
  • STATUS
  • STDDEV_POP
  • STDDEV_SAMP
  • STDDEV
  • STORAGE
  • STORED
  • STRAIGHT_JOIN
  • STRING
  • SUBCLASS_ORIGIN
  • SUBJECT
  • SUBPARTITION
  • SUBPARTITIONS
  • SUBSTRING
  • SUM
  • SUPER
  • SUSPEND
  • SWAPS
  • SWITCHES

T

  • TABLE
  • TABLES
  • TABLESPACE
  • TABLE_CHECKSUM
  • TABLE_NAME
  • TEMPORARY
  • TEMPTABLE
  • TERMINATED
  • TEXT
  • THAN
  • THEN
  • TIME
  • TIMESTAMP
  • TIMESTAMPADD
  • TIMESTAMPDIFF
  • TINYBLOB
  • TINYINT
  • TINYTEXT
  • TO
  • TRAILING
  • TRANSACTION
  • TRIGGER
  • TRIGGERS
  • TRUE
  • TRUNCATE
  • TYPE
  • TYPES
  • UNDO
  • UNDO_BUFFER_SIZE
  • UNION
  • UNIQUE
  • UNLOCK
  • UNSIGNED
  • UPDATE
  • USAGE
  • USE
  • USER
  • USE_FRM
  • USING
  • UTC_DATE
  • UTC_TIME
  • UTC_TIMESTAMP
  • VALIDATION
  • VALUE
  • VALUES
  • VARBINARY
  • VARCHAR
  • VARCHARACTER
  • VARIABLES
  • VARIANCE
  • VARYING
  • VIEW
  • VIRTUAL

W

  • WAIT
  • WARNINGS
  • WEEK
  • WEIGHT_STRING
  • WHEN
  • WHERE
  • WHILE
  • WITH
  • WITHOUT
  • WORK
  • WRAPPER
  • WRITE

X

  • XOR

Z

  • ZEROFILL

以上是MySQL的保留字列表,使用时应避免将这些词作为标识符名称,以免引发语法错误或行为异常。