以下是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
- 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的保留字列表,使用时应避免将这些词作为标识符名称,以免引发语法错误或行为异常。