首页 > 数据库 > MySQL

MySQL8.0关键字和保留词汇总（转载）

来源：SegmentFault

时间：2023-01-27 11:59:11 494浏览收藏

小伙伴们有没有觉得学习数据库很有意思？有意思就对了！今天就给大家带来《MySQL8.0关键字和保留词汇总（转载）》，以下内容将会涉及到MySQL，若是在学习中对其中部分知识点有疑问，或许看了本文就能帮到你！

A

```
ACCESSIBLE
```
(R)
```
ACCOUNT
```
```
ACTION
```
```
ACTIVE
```
; added in 8.0.14 (nonreserved)
```
ADD
```
(R)
```
ADMIN
```
; became nonreserved in 8.0.12
```
AFTER
```
```
AGAINST
```
```
AGGREGATE
```
```
ALGORITHM
```
```
ALL
```
(R)
```
ALTER
```
(R)
```
ALWAYS
```
```
ANALYSE
```
; removed in 8.0.1
```
ANALYZE
```
(R)
```
AND
```
(R)
```
ANY
```
```
ARRAY
```
; added in 8.0.17 (reserved); became nonreserved in 8.0.19
```
AS
```
(R)
```
ASC
```
(R)
```
ASCII
```
```
ASENSITIVE
```
(R)
```
AT
```
```
ATTRIBUTE
```
; added in 8.0.21 (nonreserved)
```
AUTOEXTEND_SIZE
```
```
AUTO_INCREMENT
```
```
AVG
```
```
AVG_ROW_LENGTH
```

B

```
BACKUP
```
```
BEFORE
```
(R)
```
BEGIN
```
```
BETWEEN
```
(R)
```
BIGINT
```
(R)
```
BINARY
```
(R)
```
BINLOG
```
```
BIT
```
```
BLOB
```
(R)
```
BLOCK
```
```
BOOL
```
```
BOOLEAN
```
```
BOTH
```
(R)
```
BTREE
```
```
BUCKETS
```
; added in 8.0.2 (nonreserved)
```
BY
```
(R)
```
BYTE
```

C

```
CACHE
```
```
CALL
```
(R)
```
CASCADE
```
(R)
```
CASCADED
```
```
CASE
```
(R)
```
CATALOG_NAME
```
```
CHAIN
```
```
CHANGE
```
(R)
```
CHANGED
```
```
CHANNEL
```
```
CHAR
```
(R)
```
CHARACTER
```
(R)
```
CHARSET
```
```
CHECK
```
(R)
```
CHECKSUM
```
```
CIPHER
```
```
CLASS_ORIGIN
```
```
CLIENT
```
```
CLONE
```
; added in 8.0.3 (nonreserved)
```
CLOSE
```
```
COALESCE
```
```
CODE
```
```
COLLATE
```
(R)
```
COLLATION
```
```
COLUMN
```
(R)
```
COLUMNS
```
```
COLUMN_FORMAT
```
```
COLUMN_NAME
```
```
COMMENT
```
```
COMMIT
```
```
COMMITTED
```
```
COMPACT
```
```
COMPLETION
```
```
COMPONENT
```
```
COMPRESSED
```
```
COMPRESSION
```
```
CONCURRENT
```
```
CONDITION
```
(R)
```
CONNECTION
```
```
CONSISTENT
```
```
CONSTRAINT
```
(R)
```
CONSTRAINT_CATALOG
```
```
CONSTRAINT_NAME
```
```
CONSTRAINT_SCHEMA
```
```
CONTAINS
```
```
CONTEXT
```
```
CONTINUE
```
(R)
```
CONVERT
```
(R)
```
CPU
```
```
CREATE
```
(R)
```
CROSS
```
(R)
```
CUBE
```
(R); became reserved in 8.0.1
```
CUME_DIST
```
(R); added in 8.0.2 (reserved)
```
CURRENT
```
```
CURRENT_DATE
```
(R)
```
CURRENT_TIME
```
(R)
```
CURRENT_TIMESTAMP
```
(R)
```
CURRENT_USER
```
(R)
```
CURSOR
```
(R)
```
CURSOR_NAME
```

D

```
DATA
```
```
DATABASE
```
(R)
```
DATABASES
```
(R)
```
DATAFILE
```
```
DATE
```
```
DATETIME
```
```
DAY
```
```
DAY_HOUR
```
(R)
```
DAY_MICROSECOND
```
(R)
```
DAY_MINUTE
```
(R)
```
DAY_SECOND
```
(R)
```
DEALLOCATE
```
```
DEC
```
(R)
```
DECIMAL
```
(R)
```
DECLARE
```
(R)
```
DEFAULT
```
(R)
```
DEFAULT_AUTH
```
```
DEFINER
```
```
DEFINITION
```
; added in 8.0.4 (nonreserved)
```
DELAYED
```
(R)
```
DELAY_KEY_WRITE
```
```
DELETE
```
(R)
```
DENSE_RANK
```
(R); added in 8.0.2 (reserved)
```
DESC
```
(R)
```
DESCRIBE
```
(R)
```
DESCRIPTION
```
; added in 8.0.4 (nonreserved)
```
DES_KEY_FILE
```
; removed in 8.0.3
```
DETERMINISTIC
```
(R)
```
DIAGNOSTICS
```
```
DIRECTORY
```
```
DISABLE
```
```
DISCARD
```
```
DISK
```
```
DISTINCT
```
(R)
```
DISTINCTROW
```
(R)
```
DIV
```
(R)
```
DO
```
```
DOUBLE
```
(R)
```
DROP
```
(R)
```
DUAL
```
(R)
```
DUMPFILE
```
```
DUPLICATE
```
```
DYNAMIC
```

E

```
EACH
```
(R)
```
ELSE
```
(R)
```
ELSEIF
```
(R)
```
EMPTY
```
(R); added in 8.0.4 (reserved)
```
ENABLE
```
```
ENCLOSED
```
(R)
```
ENCRYPTION
```
```
END
```
```
ENDS
```
```
ENFORCED
```
; added in 8.0.16 (nonreserved)
```
ENGINE
```
```
ENGINES
```
```
ENGINE_ATTRIBUTE
```
; added in 8.0.21 (nonreserved)
```
ENUM
```
```
ERROR
```
```
ERRORS
```
```
ESCAPE
```
```
ESCAPED
```
(R)
```
EVENT
```
```
EVENTS
```
```
EVERY
```
```
EXCEPT
```
(R)
```
EXCHANGE
```
```
EXCLUDE
```
; added in 8.0.2 (nonreserved)
```
EXECUTE
```
```
EXISTS
```
(R)
```
EXIT
```
(R)
```
EXPANSION
```
```
EXPIRE
```
```
EXPLAIN
```
(R)
```
EXPORT
```
```
EXTENDED
```
```
EXTENT_SIZE
```

F

```
FAILED_LOGIN_ATTEMPTS
```
; added in 8.0.19 (nonreserved)
```
FALSE
```
(R)
```
FAST
```
```
FAULTS
```
```
FETCH
```
(R)
```
FIELDS
```
```
FILE
```
```
FILE_BLOCK_SIZE
```
```
FILTER
```
```
FIRST
```
```
FIRST_VALUE
```
(R); added in 8.0.2 (reserved)
```
FIXED
```
```
FLOAT
```
(R)
```
FLOAT4
```
(R)
```
FLOAT8
```
(R)
```
FLUSH
```
```
FOLLOWING
```
; added in 8.0.2 (nonreserved)
```
FOLLOWS
```
```
FOR
```
(R)
```
FORCE
```
(R)
```
FOREIGN
```
(R)
```
FORMAT
```
```
FOUND
```
```
FROM
```
(R)
```
FULL
```
```
FULLTEXT
```
(R)
```
FUNCTION
```
(R); became reserved in 8.0.1

G

```
GENERAL
```
```
GENERATED
```
(R)
```
GEOMCOLLECTION
```
; added in 8.0.11 (nonreserved)
```
GEOMETRY
```
```
GEOMETRYCOLLECTION
```
```
GET
```
(R)
```
GET_FORMAT
```
```
GET_MASTER_PUBLIC_KEY
```
; added in 8.0.4 (reserved); became nonreserved in 8.0.11
```
GLOBAL
```
```
GRANT
```
(R)
```
GRANTS
```
```
GROUP
```
(R)
```
GROUPING
```
(R); added in 8.0.1 (reserved)
```
GROUPS
```
(R); added in 8.0.2 (reserved)
```
GROUP_REPLICATION
```

H

```
HANDLER
```
```
HASH
```
```
HAVING
```
(R)
```
HELP
```
```
HIGH_PRIORITY
```
(R)
```
HISTOGRAM
```
; added in 8.0.2 (nonreserved)
```
HISTORY
```
; added in 8.0.3 (nonreserved)
```
HOST
```
```
HOSTS
```
```
HOUR
```
```
HOUR_MICROSECOND
```
(R)
```
HOUR_MINUTE
```
(R)
```
HOUR_SECOND
```
(R)

I

```
IDENTIFIED
```
```
IF
```
(R)
```
IGNORE
```
(R)
```
IGNORE_SERVER_IDS
```
```
IMPORT
```
```
IN
```
(R)
```
INACTIVE
```
; added in 8.0.14 (nonreserved)
```
INDEX
```
(R)
```
INDEXES
```
```
INFILE
```
(R)
```
INITIAL_SIZE
```
```
INNER
```
(R)
```
INOUT
```
(R)
```
INSENSITIVE
```
(R)
```
INSERT
```
(R)
```
INSERT_METHOD
```
```
INSTALL
```
```
INSTANCE
```
```
INT
```
(R)
```
INT1
```
(R)
```
INT2
```
(R)
```
INT3
```
(R)
```
INT4
```
(R)
```
INT8
```
(R)
```
INTEGER
```
(R)
```
INTERVAL
```
(R)
```
INTO
```
(R)
```
INVISIBLE
```
```
INVOKER
```
```
IO
```
```
IO_AFTER_GTIDS
```
(R)
```
IO_BEFORE_GTIDS
```
(R)
```
IO_THREAD
```
```
IPC
```
```
IS
```
(R)
```
ISOLATION
```
```
ISSUER
```
```
ITERATE
```
(R)

J

```
JOIN
```
(R)
```
JSON
```
```
JSON_TABLE
```
(R); added in 8.0.4 (reserved)
```
JSON_VALUE
```
; added in 8.0.21 (nonreserved)

K

```
KEY
```
(R)
```
KEYS
```
(R)
```
KEY_BLOCK_SIZE
```
```
KILL
```
(R)

L

```
LAG
```
(R); added in 8.0.2 (reserved)
```
LANGUAGE
```
```
LAST
```
```
LAST_VALUE
```
(R); added in 8.0.2 (reserved)
```
LATERAL
```
(R); added in 8.0.14 (reserved)
```
LEAD
```
(R); added in 8.0.2 (reserved)
```
LEADING
```
(R)
```
LEAVE
```
(R)
```
LEAVES
```
```
LEFT
```
(R)
```
LESS
```
```
LEVEL
```
```
LIKE
```
(R)
```
LIMIT
```
(R)
```
LINEAR
```
(R)
```
LINES
```
(R)
```
LINESTRING
```
```
LIST
```
```
LOAD
```
(R)
```
LOCAL
```
```
LOCALTIME
```
(R)
```
LOCALTIMESTAMP
```
(R)
```
LOCK
```
(R)
```
LOCKED
```
; added in 8.0.1 (nonreserved)
```
LOCKS
```
```
LOGFILE
```
```
LOGS
```
```
LONG
```
(R)
```
LONGBLOB
```
(R)
```
LONGTEXT
```
(R)
```
LOOP
```
(R)
```
LOW_PRIORITY
```
(R)

M

```
MASTER
```
```
MASTER_AUTO_POSITION
```
```
MASTER_BIND
```
(R)
```
MASTER_COMPRESSION_ALGORITHMS
```
; added in 8.0.18 (nonreserved)
```
MASTER_CONNECT_RETRY
```
```
MASTER_DELAY
```
```
MASTER_HEARTBEAT_PERIOD
```
```
MASTER_HOST
```
```
MASTER_LOG_FILE
```
```
MASTER_LOG_POS
```
```
MASTER_PASSWORD
```
```
MASTER_PORT
```
```
MASTER_PUBLIC_KEY_PATH
```
; added in 8.0.4 (nonreserved)
```
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
```
(R)
```
MASTER_TLS_CIPHERSUITES
```
; added in 8.0.19 (nonreserved)
```
MASTER_TLS_VERSION
```
```
MASTER_USER
```
```
MASTER_ZSTD_COMPRESSION_LEVEL
```
; added in 8.0.18 (nonreserved)
```
MATCH
```
(R)
```
MAXVALUE
```
(R)
```
MAX_CONNECTIONS_PER_HOUR
```
```
MAX_QUERIES_PER_HOUR
```
```
MAX_ROWS
```
```
MAX_SIZE
```
```
MAX_UPDATES_PER_HOUR
```
```
MAX_USER_CONNECTIONS
```
```
MEDIUM
```
```
MEDIUMBLOB
```
(R)
```
MEDIUMINT
```
(R)
```
MEDIUMTEXT
```
(R)
```
MEMBER
```
; added in 8.0.17 (reserved); became nonreserved in 8.0.19
```
MEMORY
```
```
MERGE
```
```
MESSAGE_TEXT
```
```
MICROSECOND
```
```
MIDDLEINT
```
(R)
```
MIGRATE
```
```
MINUTE
```
```
MINUTE_MICROSECOND
```
(R)
```
MINUTE_SECOND
```
(R)
```
MIN_ROWS
```
```
MOD
```
(R)
```
MODE
```
```
MODIFIES
```
(R)
```
MODIFY
```
```
MONTH
```
```
MULTILINESTRING
```
```
MULTIPOINT
```
```
MULTIPOLYGON
```
```
MUTEX
```
```
MYSQL_ERRNO
```

N

```
NAME
```
```
NAMES
```
```
NATIONAL
```
```
NATURAL
```
(R)
```
NCHAR
```
```
NDB
```
```
NDBCLUSTER
```
```
NESTED
```
; added in 8.0.4 (nonreserved)
```
NETWORK_NAMESPACE
```
; added in 8.0.16 (nonreserved)
```
NEVER
```
```
NEW
```
```
NEXT
```
```
NO
```
```
NODEGROUP
```
```
NONE
```
```
NOT
```
(R)
```
NOWAIT
```
; added in 8.0.1 (nonreserved)
```
NO_WAIT
```
```
NO_WRITE_TO_BINLOG
```
(R)
```
NTH_VALUE
```
(R); added in 8.0.2 (reserved)
```
NTILE
```
(R); added in 8.0.2 (reserved)
```
NULL
```
(R)
```
NULLS
```
; added in 8.0.2 (nonreserved)
```
NUMBER
```
```
NUMERIC
```
(R)
```
NVARCHAR
```

O

```
OF
```
(R); added in 8.0.1 (reserved)
```
OFF
```
; added in 8.0.20 (nonreserved)
```
OFFSET
```
```
OJ
```
; added in 8.0.16 (nonreserved)
```
OLD
```
; added in 8.0.14 (nonreserved)
```
ON
```
(R)
```
ONE
```
```
ONLY
```
```
OPEN
```
```
OPTIMIZE
```
(R)
```
OPTIMIZER_COSTS
```
(R)
```
OPTION
```
(R)
```
OPTIONAL
```
; added in 8.0.13 (nonreserved)
```
OPTIONALLY
```
(R)
```
OPTIONS
```
```
OR
```
(R)
```
ORDER
```
(R)
```
ORDINALITY
```
; added in 8.0.4 (nonreserved)
```
ORGANIZATION
```
; added in 8.0.4 (nonreserved)
```
OTHERS
```
; added in 8.0.2 (nonreserved)
```
OUT
```
(R)
```
OUTER
```
(R)
```
OUTFILE
```
(R)
```
OVER
```
(R); added in 8.0.2 (reserved)
```
OWNER
```

P

```
PACK_KEYS
```
```
PAGE
```
```
PARSER
```
```
PARTIAL
```
```
PARTITION
```
(R)
```
PARTITIONING
```
```
PARTITIONS
```
```
PASSWORD
```
```
PASSWORD_LOCK_TIME
```
; added in 8.0.19 (nonreserved)
```
PATH
```
; added in 8.0.4 (nonreserved)
```
PERCENT_RANK
```
(R); added in 8.0.2 (reserved)
```
PERSIST
```
; became nonreserved in 8.0.16
```
PERSIST_ONLY
```
; added in 8.0.2 (reserved); became nonreserved in 8.0.16
```
PHASE
```
```
PLUGIN
```
```
PLUGINS
```
```
PLUGIN_DIR
```
```
POINT
```
```
POLYGON
```
```
PORT
```
```
PRECEDES
```
```
PRECEDING
```
; added in 8.0.2 (nonreserved)
```
PRECISION
```
(R)
```
PREPARE
```
```
PRESERVE
```
```
PREV
```
```
PRIMARY
```
(R)
```
PRIVILEGES
```
```
PRIVILEGE_CHECKS_USER
```
; added in 8.0.18 (nonreserved)
```
PROCEDURE
```
(R)
```
PROCESS
```
; added in 8.0.11 (nonreserved)
```
PROCESSLIST
```
```
PROFILE
```
```
PROFILES
```
```
PROXY
```
```
PURGE
```
(R)

Q

```
QUARTER
```
```
QUERY
```
```
QUICK
```

R

```
RANDOM
```
; added in 8.0.18 (nonreserved)
```
RANGE
```
(R)
```
RANK
```
(R); added in 8.0.2 (reserved)
```
READ
```
(R)
```
READS
```
(R)
```
READ_ONLY
```
```
READ_WRITE
```
(R)
```
REAL
```
(R)
```
REBUILD
```
```
RECOVER
```
```
RECURSIVE
```
(R); added in 8.0.1 (reserved)
```
REDOFILE
```
; removed in 8.0.3
```
REDO_BUFFER_SIZE
```
```
REDUNDANT
```
```
REFERENCE
```
; added in 8.0.4 (nonreserved)
```
REFERENCES
```
(R)
```
REGEXP
```
(R)
```
RELAY
```
```
RELAYLOG
```
```
RELAY_LOG_FILE
```
```
RELAY_LOG_POS
```
```
RELAY_THREAD
```
```
RELEASE
```
(R)
```
RELOAD
```
```
REMOTE
```
; added in 8.0.3 (nonreserved); removed in 8.0.14
```
REMOVE
```
```
RENAME
```
(R)
```
REORGANIZE
```
```
REPAIR
```
```
REPEAT
```
(R)
```
REPEATABLE
```
```
REPLACE
```
(R)
```
REPLICA
```
; added in 8.0.22 (nonreserved)
```
REPLICAS
```
; added in 8.0.22 (nonreserved)
```
REPLICATE_DO_DB
```
```
REPLICATE_DO_TABLE
```
```
REPLICATE_IGNORE_DB
```
```
REPLICATE_IGNORE_TABLE
```
```
REPLICATE_REWRITE_DB
```
```
REPLICATE_WILD_DO_TABLE
```
```
REPLICATE_WILD_IGNORE_TABLE
```
```
REPLICATION
```
```
REQUIRE
```
(R)
```
REQUIRE_ROW_FORMAT
```
; added in 8.0.19 (nonreserved)
```
RESET
```
```
RESIGNAL
```
(R)
```
RESOURCE
```
; added in 8.0.3 (nonreserved)
```
RESPECT
```
; added in 8.0.2 (nonreserved)
```
RESTART
```
; added in 8.0.4 (nonreserved)
```
RESTORE
```
```
RESTRICT
```
(R)
```
RESUME
```
```
RETAIN
```
; added in 8.0.14 (nonreserved)
```
RETURN
```
(R)
```
RETURNED_SQLSTATE
```
```
RETURNING
```
; added in 8.0.21 (nonreserved)
```
RETURNS
```
```
REUSE
```
; added in 8.0.3 (nonreserved)
```
REVERSE
```
```
REVOKE
```
(R)
```
RIGHT
```
(R)
```
RLIKE
```
(R)
```
ROLE
```
; became nonreserved in 8.0.1
```
ROLLBACK
```
```
ROLLUP
```
```
ROTATE
```
```
ROUTINE
```
```
ROW
```
(R); became reserved in 8.0.2
```
ROWS
```
(R); became reserved in 8.0.2
```
ROW_COUNT
```
```
ROW_FORMAT
```
```
ROW_NUMBER
```
(R); added in 8.0.2 (reserved)
```
RTREE
```

S

```
SAVEPOINT
```
```
SCHEDULE
```
```
SCHEMA
```
(R)
```
SCHEMAS
```
(R)
```
SCHEMA_NAME
```
```
SECOND
```
```
SECONDARY
```
; added in 8.0.16 (nonreserved)
```
SECONDARY_ENGINE
```
; added in 8.0.13 (nonreserved)
```
SECONDARY_ENGINE_ATTRIBUTE
```
; added in 8.0.21 (nonreserved)
```
SECONDARY_LOAD
```
; added in 8.0.13 (nonreserved)
```
SECONDARY_UNLOAD
```
; added in 8.0.13 (nonreserved)
```
SECOND_MICROSECOND
```
(R)
```
SECURITY
```
```
SELECT
```
(R)
```
SENSITIVE
```
(R)
```
SEPARATOR
```
(R)
```
SERIAL
```
```
SERIALIZABLE
```
```
SERVER
```
```
SESSION
```
```
SET
```
(R)
```
SHARE
```
```
SHOW
```
(R)
```
SHUTDOWN
```
```
SIGNAL
```
(R)
```
SIGNED
```
```
SIMPLE
```
```
SKIP
```
; added in 8.0.1 (nonreserved)
```
SLAVE
```
```
SLOW
```
```
SMALLINT
```
(R)
```
SNAPSHOT
```
```
SOCKET
```
```
SOME
```
```
SONAME
```
```
SOUNDS
```
```
SOURCE
```
```
SPATIAL
```
(R)
```
SPECIFIC
```
(R)
```
SQL
```
(R)
```
SQLEXCEPTION
```
(R)
```
SQLSTATE
```
(R)
```
SQLWARNING
```
(R)
```
SQL_AFTER_GTIDS
```
```
SQL_AFTER_MTS_GAPS
```
```
SQL_BEFORE_GTIDS
```
```
SQL_BIG_RESULT
```
(R)
```
SQL_BUFFER_RESULT
```
```
SQL_CACHE
```
; removed in 8.0.3
```
SQL_CALC_FOUND_ROWS
```
(R)
```
SQL_NO_CACHE
```
```
SQL_SMALL_RESULT
```
(R)
```
SQL_THREAD
```
```
SQL_TSI_DAY
```
```
SQL_TSI_HOUR
```
```
SQL_TSI_MINUTE
```
```
SQL_TSI_MONTH
```
```
SQL_TSI_QUARTER
```
```
SQL_TSI_SECOND
```
```
SQL_TSI_WEEK
```
```
SQL_TSI_YEAR
```
```
SRID
```
; added in 8.0.3 (nonreserved)
```
SSL
```
(R)
```
STACKED
```
```
START
```
```
STARTING
```
(R)
```
STARTS
```
```
STATS_AUTO_RECALC
```
```
STATS_PERSISTENT
```
```
STATS_SAMPLE_PAGES
```
```
STATUS
```
```
STOP
```
```
STORAGE
```
```
STORED
```
(R)
```
STRAIGHT_JOIN
```
(R)
```
STREAM
```
; added in 8.0.20 (nonreserved)
```
STRING
```
```
SUBCLASS_ORIGIN
```
```
SUBJECT
```
```
SUBPARTITION
```
```
SUBPARTITIONS
```
```
SUPER
```
```
SUSPEND
```
```
SWAPS
```
```
SWITCHES
```
```
SYSTEM
```
(R); added in 8.0.3 (reserved)

T

```
TABLE
```
(R)
```
TABLES
```
```
TABLESPACE
```
```
TABLE_CHECKSUM
```
```
TABLE_NAME
```
```
TEMPORARY
```
```
TEMPTABLE
```
```
TERMINATED
```
(R)
```
TEXT
```
```
THAN
```
```
THEN
```
(R)
```
THREAD_PRIORITY
```
; added in 8.0.3 (nonreserved)
```
TIES
```
; added in 8.0.2 (nonreserved)
```
TIME
```
```
TIMESTAMP
```
```
TIMESTAMPADD
```
```
TIMESTAMPDIFF
```
```
TINYBLOB
```
(R)
```
TINYINT
```
(R)
```
TINYTEXT
```
(R)
```
TLS
```
; added in 8.0.21 (nonreserved)
```
TO
```
(R)
```
TRAILING
```
(R)
```
TRANSACTION
```
```
TRIGGER
```
(R)
```
TRIGGERS
```
```
TRUE
```
(R)
```
TRUNCATE
```
```
TYPE
```
```
TYPES
```

U

```
UNBOUNDED
```
; added in 8.0.2 (nonreserved)
```
UNCOMMITTED
```
```
UNDEFINED
```
```
UNDO
```
(R)
```
UNDOFILE
```
```
UNDO_BUFFER_SIZE
```
```
UNICODE
```
```
UNINSTALL
```
```
UNION
```
(R)
```
UNIQUE
```
(R)
```
UNKNOWN
```
```
UNLOCK
```
(R)
```
UNSIGNED
```
(R)
```
UNTIL
```
```
UPDATE
```
(R)
```
UPGRADE
```
```
USAGE
```
(R)
```
USE
```
(R)
```
USER
```
```
USER_RESOURCES
```
```
USE_FRM
```
```
USING
```
(R)
```
UTC_DATE
```
(R)
```
UTC_TIME
```
(R)
```
UTC_TIMESTAMP
```
(R)

V

```
VALIDATION
```
```
VALUE
```
```
VALUES
```
(R)
```
VARBINARY
```
(R)
```
VARCHAR
```
(R)
```
VARCHARACTER
```
(R)
```
VARIABLES
```
```
VARYING
```
(R)
```
VCPU
```
; added in 8.0.3 (nonreserved)
```
VIEW
```
```
VIRTUAL
```
(R)
```
VISIBLE
```

W

```
WAIT
```
```
WARNINGS
```
```
WEEK
```
```
WEIGHT_STRING
```
```
WHEN
```
(R)
```
WHERE
```
(R)
```
WHILE
```
(R)
```
WINDOW
```
(R); added in 8.0.2 (reserved)
```
WITH
```
(R)
```
WITHOUT
```
```
WORK
```
```
WRAPPER
```
```
WRITE
```
(R)

X

```
X509
```
```
XA
```
```
XID
```
```
XML
```
```
XOR
```
(R)

Y

```
YEAR
```
```
YEAR_MONTH
```
(R)

Z

```
ZEROFILL
```
(R)
```
ZONE
```
; added in 8.0.22 (nonreserved)

MySQL 8.0新关键字和保留字

下表显示了与MySQL 5.7相比在MySQL 8.0中添加的关键字和保留字。保留的关键字标有（R）。

A

```
ACTIVE
```
```
ADMIN
```
```
ARRAY
```
```
ATTRIBUTE
```

B

```
BUCKETS
```

C

```
CLONE
```
```
COMPONENT
```
```
CUME_DIST
```
(R)

D

```
DEFINITION
```
```
DENSE_RANK
```
(R)
```
DESCRIPTION
```

E

```
EMPTY
```
(R)
```
ENFORCED
```
```
ENGINE_ATTRIBUTE
```
```
EXCEPT
```
(R)
```
EXCLUDE
```

F

```
FAILED_LOGIN_ATTEMPTS
```
```
FIRST_VALUE
```
(R)
```
FOLLOWING
```

G

```
GEOMCOLLECTION
```
```
GET_MASTER_PUBLIC_KEY
```
```
GROUPING
```
(R)
```
GROUPS
```
(R)

H

```
HISTOGRAM
```
```
HISTORY
```

I

```
INACTIVE
```
```
INVISIBLE
```

J

```
JSON_TABLE
```
(R)
```
JSON_VALUE
```

L

```
LAG
```
(R)
```
LAST_VALUE
```
(R)
```
LATERAL
```
(R)
```
LEAD
```
(R)
```
LOCKED
```

M

```
MASTER_COMPRESSION_ALGORITHMS
```
```
MASTER_PUBLIC_KEY_PATH
```
```
MASTER_TLS_CIPHERSUITES
```
```
MASTER_ZSTD_COMPRESSION_LEVEL
```
```
MEMBER
```

N

```
NESTED
```
```
NETWORK_NAMESPACE
```
```
NOWAIT
```
```
NTH_VALUE
```
(R)
```
NTILE
```
(R)
```
NULLS
```

O

```
OF
```
(R)
```
OFF
```
```
OJ
```
```
OLD
```
```
OPTIONAL
```
```
ORDINALITY
```
```
ORGANIZATION
```
```
OTHERS
```
```
OVER
```
(R)

P

```
PASSWORD_LOCK_TIME
```
```
PATH
```
```
PERCENT_RANK
```
(R)
```
PERSIST
```
```
PERSIST_ONLY
```
```
PRECEDING
```
```
PRIVILEGE_CHECKS_USER
```
```
PROCESS
```

R

```
RANDOM
```
```
RANK
```
(R)
```
RECURSIVE
```
(R)
```
REFERENCE
```
```
REPLICA
```
```
REPLICAS
```
```
REQUIRE_ROW_FORMAT
```
```
RESOURCE
```
```
RESPECT
```
```
RESTART
```
```
RETAIN
```
```
RETURNING
```
```
REUSE
```
```
ROLE
```
```
ROW_NUMBER
```
(R)

S

```
SECONDARY
```
```
SECONDARY_ENGINE
```
```
SECONDARY_ENGINE_ATTRIBUTE
```
```
SECONDARY_LOAD
```
```
SECONDARY_UNLOAD
```
```
SKIP
```
```
SRID
```
```
STREAM
```
```
SYSTEM
```
(R)

T

```
THREAD_PRIORITY
```
```
TIES
```
```
TLS
```

U

```
UNBOUNDED
```

V

```
VCPU
```
```
VISIBLE
```

W

```
WINDOW
```
(R)

Z

```
ZONE
```

MySQL 8.0删除了关键字和保留字

下表显示了与MySQL 5.7相比在MySQL 8.0中删除的关键字和保留字。保留的关键字标有（R）。

```
ANALYSE
```
```
DES_KEY_FILE
```
```
PARSE_GCOL_EXPR
```
```
REDOFILE
```
```
SQL_CACHE
```
出处：https://www.cnblogs.com/yuchu...

终于介绍完啦！小伙伴们，这篇关于《MySQL8.0关键字和保留词汇总（转载）》的介绍应该让你收获多多了吧！欢迎大家收藏或分享给更多需要学习的朋友吧~golang学习网公众号也会发布数据库相关知识，快来关注吧！

mysql MySQL

声明：本文转载于：SegmentFault 如有侵犯，请联系study_golang@163.com删除