## 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`