服务器运维

MySQL 8.0 关键字和保留字

机翻:

下面的列表显示了 MySQL 8.0 中的关键字和保留字,以及各个版本中各个单词的变化。保留关键字用 (R) 标记。另外,_FILENAME是保留的。

在某些时候,您可能会升级到更高版本,因此最好也看看未来的保留字。您可以在涵盖更高版本 MySQL 的手册中找到这些内容。标准 SQL 禁止使用列表中的大多数保留字作为列名或表名(例如, GROUP)。其中一些被保留,因为 MySQL 需要它们并使用yacc解析器。

原文地址: https://dev.mysql.com/doc/refman/8.0/en/keywords.html

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)
  • AUTHENTICATION; added in 8.0.27 (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)
  • BULK; added in 8.0.32 (nonreserved)
  • BY (R)
  • BYTE

C

  • CACHE
  • CALL (R)
  • CASCADE (R)
  • CASCADED
  • CASE (R)
  • CATALOG_NAME
  • CHAIN
  • CHALLENGE_RESPONSE; added in 8.0.27 (nonreserved)
  • 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

  • FACTOR; added in 8.0.27 (nonreserved)
  • FAILED_LOGIN_ATTEMPTS; added in 8.0.19 (nonreserved)
  • FALSE (R)
  • FAST
  • FAULTS
  • FETCH (R)
  • FIELDS
  • FILE
  • FILE_BLOCK_SIZE
  • FILTER
  • FINISH; added in 8.0.27 (nonreserved)
  • 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
  • GENERATE; added in 8.0.32 (nonreserved)
  • 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
  • GET_SOURCE_PUBLIC_KEY; added in 8.0.23 (nonreserved)
  • GLOBAL
  • GRANT (R)
  • GRANTS
  • GROUP (R)
  • GROUPING (R); added in 8.0.1 (reserved)
  • GROUPS (R); added in 8.0.2 (reserved)
  • GROUP_REPLICATION
  • GTID_ONLY; added in 8.0.27 (nonreserved)

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; added in 8.0.27 (nonreserved)
  • INITIAL_SIZE
  • INITIATE; added in 8.0.27 (nonreserved)
  • 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)
  • INTERSECT (R); added in 8.0.31 (reserved)
  • 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)
  • KEYRING; added in 8.0.24 (nonreserved)
  • 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; removed in 8.0.23
  • 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)
  • REGISTRATION; added in 8.0.27 (nonreserved)
  • 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
  • SOURCE_AUTO_POSITION; added in 8.0.23 (nonreserved)
  • SOURCE_BIND; added in 8.0.23 (nonreserved)
  • SOURCE_COMPRESSION_ALGORITHMS; added in 8.0.23 (nonreserved)
  • SOURCE_CONNECT_RETRY; added in 8.0.23 (nonreserved)
  • SOURCE_DELAY; added in 8.0.23 (nonreserved)
  • SOURCE_HEARTBEAT_PERIOD; added in 8.0.23 (nonreserved)
  • SOURCE_HOST; added in 8.0.23 (nonreserved)
  • SOURCE_LOG_FILE; added in 8.0.23 (nonreserved)
  • SOURCE_LOG_POS; added in 8.0.23 (nonreserved)
  • SOURCE_PASSWORD; added in 8.0.23 (nonreserved)
  • SOURCE_PORT; added in 8.0.23 (nonreserved)
  • SOURCE_PUBLIC_KEY_PATH; added in 8.0.23 (nonreserved)
  • SOURCE_RETRY_COUNT; added in 8.0.23 (nonreserved)
  • SOURCE_SSL; added in 8.0.23 (nonreserved)
  • SOURCE_SSL_CA; added in 8.0.23 (nonreserved)
  • SOURCE_SSL_CAPATH; added in 8.0.23 (nonreserved)
  • SOURCE_SSL_CERT; added in 8.0.23 (nonreserved)
  • SOURCE_SSL_CIPHER; added in 8.0.23 (nonreserved)
  • SOURCE_SSL_CRL; added in 8.0.23 (nonreserved)
  • SOURCE_SSL_CRLPATH; added in 8.0.23 (nonreserved)
  • SOURCE_SSL_KEY; added in 8.0.23 (nonreserved)
  • SOURCE_SSL_VERIFY_SERVER_CERT; added in 8.0.23 (nonreserved)
  • SOURCE_TLS_CIPHERSUITES; added in 8.0.23 (nonreserved)
  • SOURCE_TLS_VERSION; added in 8.0.23 (nonreserved)
  • SOURCE_USER; added in 8.0.23 (nonreserved)
  • SOURCE_ZSTD_COMPRESSION_LEVEL; added in 8.0.23 (nonreserved)
  • 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)
  • UNREGISTER; added in 8.0.27 (nonreserved)
  • UNSIGNED (R)
  • UNTIL
  • UPDATE (R)
  • UPGRADE
  • URL; added in 8.0.32 (nonreserved)
  • 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 New Keywords and Reserved Words

The following list shows the keywords and reserved words that are added in MySQL 8.0, compared to MySQL 5.7. Reserved keywords are marked with (R).

A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | R | S | T | U | V | W | Z

A

  • ACTIVE
  • ADMIN
  • ARRAY
  • ATTRIBUTE
  • AUTHENTICATION

B

  • BUCKETS
  • BULK

C

  • CHALLENGE_RESPONSE
  • CLONE
  • COMPONENT
  • CUME_DIST (R)

D

  • DEFINITION
  • DENSE_RANK (R)
  • DESCRIPTION

E

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

F

  • FACTOR
  • FAILED_LOGIN_ATTEMPTS
  • FINISH
  • FIRST_VALUE (R)
  • FOLLOWING

G

  • GENERATE
  • GEOMCOLLECTION
  • GET_MASTER_PUBLIC_KEY
  • GET_SOURCE_PUBLIC_KEY
  • GROUPING (R)
  • GROUPS (R)
  • GTID_ONLY

H

  • HISTOGRAM
  • HISTORY

I

  • INACTIVE
  • INITIAL
  • INITIATE
  • INTERSECT (R)
  • INVISIBLE

J

  • JSON_TABLE (R)
  • JSON_VALUE

K

  • KEYRING

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
  • REGISTRATION
  • 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
  • SOURCE_AUTO_POSITION
  • SOURCE_BIND
  • SOURCE_COMPRESSION_ALGORITHMS
  • SOURCE_CONNECT_RETRY
  • SOURCE_DELAY
  • SOURCE_HEARTBEAT_PERIOD
  • SOURCE_HOST
  • SOURCE_LOG_FILE
  • SOURCE_LOG_POS
  • SOURCE_PASSWORD
  • SOURCE_PORT
  • SOURCE_PUBLIC_KEY_PATH
  • SOURCE_RETRY_COUNT
  • 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_CIPHERSUITES
  • SOURCE_TLS_VERSION
  • SOURCE_USER
  • SOURCE_ZSTD_COMPRESSION_LEVEL
  • SRID
  • STREAM
  • SYSTEM (R)

T

  • THREAD_PRIORITY
  • TIES
  • TLS

U

  • UNBOUNDED
  • UNREGISTER
  • URL

V

  • VCPU
  • VISIBLE

W

  • WINDOW (R)

Z

  • ZONE

Leave a Reply

Your email address will not be published. Required fields are marked *