MySQL 关键字和保留字汇总(MySQL 8.0)

## MySQL 关键字以及保留字

关键字是在SQL中具有重要意义的单词。某些关键字,如
[`SELECT`](https://dev.mysql.com/doc/refman/8.0/en/select.html)
[`DELETE`](https://dev.mysql.com/doc/refman/8.0/en/delete.html)
[`BIGINT`](https://dev.mysql.com/doc/refman/8.0/en/integer-types.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)
- `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`

  

 

posted @ 2020-10-27 14:58  一世尘梦(Aion)  阅读(3699)  评论(0编辑  收藏  举报