暂无图片
暂无图片
暂无图片
暂无图片
暂无图片

MySQL的语言结构 - 关键字和保留字

数据库杂货铺 2021-05-18
3561
关键字和保留字
 
关键字是在 SQL 中有意义的词。某些关键字(如 SELECTDELETE BIGINT)是保留的,需要特殊处理才能用作表名和列名等标识符。对于内置函数的名称也是如此。
 
允许不带引号的非保留关键字作为标识符。保留关键字需要按照模式对象名称中的描述进行引用,才能作为标识符:
 
    mysql> CREATE TABLE interval (begin INT, end INT);
    ERROR 1064 (42000): You have an error in your SQL syntax ...
    near 'interval (begin INT, end INT)'
     
    BEGIN END 是关键字,但不是保留字,因此它们作为标识符不需要引号。INTERVAL 是保留关键字,必须引用才能用作标识符:
     
      mysql> CREATE TABLE `interval` (begin INT, end INT);
      Query OK, 0 rows affected (0.01 sec)
       
      例外:限定名中句点后的单词一定是标识符,因此即使是保留字,也不必引用:
       
        mysql> CREATE TABLE mydb.interval (begin INT, end INT);
        Query OK, 0 rows affected (0.01 sec)
         
        允许将内置函数的名称用作标识符,但可能需要谨慎使用。例如,COUNT 可以作为列名。但是,默认情况下,函数调用中函数名和后面的 ( 字符之间不允许有空格。这个要求使解析器能够区分名称是在函数调用中使用还是在非函数上下文中使用。
         
        INFORMATION_SCHEMA.KEYWORDS 表列出了 MySQL 的关键字,并指出它们是否是保留字。
         
        MySQL 8.0 关键字和保留字
         
        下面的列表显示了 MySQL 8.0 中的关键字和保留字,以及各个版本对单个关键字的更改。保留关键字用(R)标记。此外,_FILENAME 是保留字。
         
        在某个时候,可能会升级到更高版本,所以查看用于将来的保留字也是要考虑的。可以在涵盖 MySQL 更高版本的手册中找到这些。标准 SQL 禁止列表中的大多数保留字作为列或表名(例如,GROUP)。一些是保留字,因为 MySQL 需要它们,并且用于 yacc 解析器。
         
        A
        ACCESSIBLE (R), ACCOUNT, ACTION, ACTIVE; 添加于 8.0.14 (非保留字), ADD (R), ADMIN; 8.0.12 成为非保留字, AFTER, AGAINST, AGGREGATE, ALGORITHM, ALL (R), ALTER (R), ALWAYS, ANALYSE; removed in 8.0.1, ANALYZE (R), AND (R), ANY, ARRAY; 添加于 8.0.17 (保留字); 8.0.19 成为非保留字, AS (R), ASC (R), ASCII, ASENSITIVE (R), AT, ATTRIBUTE; 添加于 8.0.21 (非保留字), 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; 添加于 8.0.2 (非保留字), 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; 添加于 8.0.3 (非保留字), 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); 8.0.1 成为保留字, CUME_DIST (R); 添加于 8.0.2 (保留字), 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; 添加于 8.0.4 (非保留字), DELAYED (R), DELAY_KEY_WRITE, DELETE (R), DENSE_RANK (R); 添加于 8.0.2 (保留字), DESC (R), DESCRIBE (R), DESCRIPTION; 添加于 8.0.4 (非保留字), 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); 添加于 8.0.4 (保留字), ENABLE, ENCLOSED (R), ENCRYPTION, END, ENDS, ENFORCED; 添加于 8.0.16 (非保留字), ENGINE, ENGINES, ENGINE_ATTRIBUTE; 添加于 8.0.21 (非保留字), ENUM, ERROR, ERRORS, ESCAPE, ESCAPED (R), EVENT, EVENTS, EVERY, EXCEPT (R), EXCHANGE, EXCLUDE; 添加于 8.0.2 (非保留字), EXECUTE, EXISTS (R), EXIT (R), EXPANSION, EXPIRE, EXPLAIN (R), EXPORT, EXTENDED, EXTENT_SIZE
         
        F
        FAILED_LOGIN_ATTEMPTS; 添加于 8.0.19 (非保留字), FALSE (R), FAST, FAULTS, FETCH (R), FIELDS, FILE, FILE_BLOCK_SIZE, FILTER, FIRST, FIRST_VALUE (R); 添加于 8.0.2 (保留字), FIXED, FLOAT (R), FLOAT4 (R), FLOAT8 (R), FLUSH, FOLLOWING; 添加于 8.0.2 (非保留字), FOLLOWS, FOR (R), FORCE (R), FOREIGN (R), FORMAT, FOUND, FROM (R), FULL, FULLTEXT (R), FUNCTION (R); 8.0.1 成为保留字
         
        G
        GENERAL, GENERATED (R), GEOMCOLLECTION; 添加于 8.0.11 (非保留字), GEOMETRY, GEOMETRYCOLLECTION, GET (R), GET_FORMAT, GET_MASTER_PUBLIC_KEY; 添加于 8.0.4 (保留字); 8.0.11 成为非保留字, GET_SOURCE_PUBLIC_KEY; 添加于 8.0.23 (非保留字), GLOBAL, GRANT (R), GRANTS, GROUP (R), GROUPING (R); 添加于 8.0.1 (保留字), GROUPS (R); 添加于 8.0.2 (保留字), GROUP_REPLICATION
         
        H
        HANDLER, HASH, HAVING (R), HELP, HIGH_PRIORITY (R), HISTOGRAM; 添加于 8.0.2 (非保留字), HISTORY; 添加于 8.0.3 (非保留字), 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; 添加于 8.0.14 (非保留字), 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); 添加于 8.0.4 (保留字), JSON_VALUE; 添加于 8.0.21 (非保留字)
         
        K
        KEY (R), KEYRING; 添加于 8.0.24 (非保留字), KEYS (R), KEY_BLOCK_SIZE, KILL (R)
         
        L
        LAG (R); 添加于 8.0.2 (保留字), LANGUAGE, LAST, LAST_VALUE (R); 添加于 8.0.2 (保留字), LATERAL (R); 添加于 8.0.14 (保留字), LEAD (R); 添加于 8.0.2 (保留字), 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; 添加于 8.0.1 (非保留字), 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; 添加于 8.0.18 (非保留字), MASTER_CONNECT_RETRY, MASTER_DELAY, MASTER_HEARTBEAT_PERIOD, MASTER_HOST, MASTER_LOG_FILE, MASTER_LOG_POS, MASTER_PASSWORD, MASTER_PORT, MASTER_PUBLIC_KEY_PATH; 添加于 8.0.4 (非保留字), 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; 添加于 8.0.19 (非保留字), MASTER_TLS_VERSION, MASTER_USER, MASTER_ZSTD_COMPRESSION_LEVEL; 添加于 8.0.18 (非保留字), 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; 添加于 8.0.17 (保留字); 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; 添加于 8.0.4 (非保留字), NETWORK_NAMESPACE; 添加于 8.0.16 (非保留字), NEVER, NEW, NEXT, NO, NODEGROUP, NONE, NOT (R), NOWAIT; 添加于 8.0.1 (非保留字), NO_WAIT, NO_WRITE_TO_BINLOG (R), NTH_VALUE (R); 添加于 8.0.2 (保留字), NTILE (R); 添加于 8.0.2 (保留字), NULL (R), NULLS; 添加于 8.0.2 (非保留字), NUMBER, NUMERIC (R), NVARCHAR
         
        O
        OF (R); 添加于 8.0.1 (保留字), OFF; 添加于 8.0.20 (非保留字), OFFSET, OJ; 添加于 8.0.16 (非保留字), OLD; 添加于 8.0.14 (非保留字), ON (R), ONE, ONLY, OPEN, OPTIMIZE (R), OPTIMIZER_COSTS (R), OPTION (R), OPTIONAL; 添加于 8.0.13 (非保留字), OPTIONALLY (R), OPTIONS, OR (R), ORDER (R), ORDINALITY; 添加于 8.0.4 (非保留字), ORGANIZATION; 添加于 8.0.4 (非保留字), OTHERS; 添加于 8.0.2 (非保留字), OUT (R), OUTER (R), OUTFILE (R), OVER (R); 添加于 8.0.2 (保留字), OWNER
         
        P
        PACK_KEYS, PAGE, PARSER, PARTIAL, PARTITION (R), PARTITIONING, PARTITIONS, PASSWORD, PASSWORD_LOCK_TIME; 添加于 8.0.19 (非保留字), PATH; 添加于 8.0.4 (非保留字), PERCENT_RANK (R); 添加于 8.0.2 (保留字), PERSIST; 8.0.16 成为非保留字, PERSIST_ONLY; 添加于 8.0.2 (保留字); 8.0.16 成为非保留字, PHASE, PLUGIN, PLUGINS, PLUGIN_DIR, POINT, POLYGON, PORT, PRECEDES, PRECEDING; 添加于 8.0.2 (非保留字), PRECISION (R), PREPARE, PRESERVE, PREV, PRIMARY (R), PRIVILEGES, PRIVILEGE_CHECKS_USER; 添加于 8.0.18 (非保留字), PROCEDURE (R), PROCESS; 添加于 8.0.11 (非保留字), PROCESSLIST, PROFILE, PROFILES, PROXY, PURGE (R)
         
        Q
        QUARTER, QUERY, QUICK
         
        R
        RANDOM; 添加于 8.0.18 (非保留字), RANGE (R), RANK (R); 添加于 8.0.2 (保留字), READ (R), READS (R), READ_ONLY, READ_WRITE (R), REAL (R), REBUILD, RECOVER, RECURSIVE (R); 添加于 8.0.1 (保留字), REDOFILE; removed in 8.0.3, REDO_BUFFER_SIZE, REDUNDANT, REFERENCE; 添加于 8.0.4 (非保留字), REFERENCES (R), REGEXP (R), RELAY, RELAYLOG, RELAY_LOG_FILE, RELAY_LOG_POS, RELAY_THREAD, RELEASE (R), RELOAD, REMOTE; 添加于 8.0.3 (非保留字); removed in 8.0.14, REMOVE, RENAME (R), REORGANIZE, REPAIR, REPEAT (R), REPEATABLE, REPLACE (R), REPLICA; 添加于 8.0.22 (非保留字), REPLICAS; 添加于 8.0.22 (非保留字), 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; 添加于 8.0.19 (非保留字), RESET, RESIGNAL (R), RESOURCE; 添加于 8.0.3 (非保留字), RESPECT; 添加于 8.0.2 (非保留字), RESTART; 添加于 8.0.4 (非保留字), RESTORE, RESTRICT (R), RESUME, RETAIN; 添加于 8.0.14 (非保留字), RETURN (R), RETURNED_SQLSTATE, RETURNING; 添加于 8.0.21 (非保留字), RETURNS, REUSE; 添加于 8.0.3 (非保留字), REVERSE, REVOKE (R), RIGHT (R), RLIKE (R), ROLE; 8.0.1 成为非保留字, ROLLBACK, ROLLUP, ROTATE, ROUTINE, ROW (R); 8.0.2 成为保留字, ROWS (R); 8.0.2 成为保留字, ROW_COUNT, ROW_FORMAT, ROW_NUMBER (R); 添加于 8.0.2 (保留字), RTREE
         
        S
        SAVEPOINT, SCHEDULE, SCHEMA (R), SCHEMAS (R), SCHEMA_NAME, SECOND, SECONDARY; 添加于 8.0.16 (非保留字), SECONDARY_ENGINE; 添加于 8.0.13 (非保留字), SECONDARY_ENGINE_ATTRIBUTE; 添加于 8.0.21 (非保留字), SECONDARY_LOAD; 添加于 8.0.13 (非保留字), SECONDARY_UNLOAD; 添加于 8.0.13 (非保留字), 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; 添加于 8.0.1 (非保留字), SLAVE, SLOW, SMALLINT (R), SNAPSHOT, SOCKET, SOME, SONAME, SOUNDS, SOURCE, SOURCE_AUTO_POSITION; 添加于 8.0.23 (非保留字), SOURCE_BIND; 添加于 8.0.23 (非保留字), SOURCE_COMPRESSION_ALGORITHMS; 添加于 8.0.23 (非保留字), SOURCE_CONNECT_RETRY; 添加于 8.0.23 (非保留字), SOURCE_DELAY; 添加于 8.0.23 (非保留字), SOURCE_HEARTBEAT_PERIOD; 添加于 8.0.23 (非保留字), SOURCE_HOST; 添加于 8.0.23 (非保留字), SOURCE_LOG_FILE; 添加于 8.0.23 (非保留字), SOURCE_LOG_POS; 添加于 8.0.23 (非保留字), SOURCE_PASSWORD; 添加于 8.0.23 (非保留字), SOURCE_PORT; 添加于 8.0.23 (非保留字), SOURCE_PUBLIC_KEY_PATH; 添加于 8.0.23 (非保留字), SOURCE_RETRY_COUNT; 添加于 8.0.23 (非保留字), SOURCE_SSL; 添加于 8.0.23 (非保留字), SOURCE_SSL_CA; 添加于 8.0.23 (非保留字), SOURCE_SSL_CAPATH; 添加于 8.0.23 (非保留字), SOURCE_SSL_CERT; 添加于 8.0.23 (非保留字), SOURCE_SSL_CIPHER; 添加于 8.0.23 (非保留字), SOURCE_SSL_CRL; 添加于 8.0.23 (非保留字), SOURCE_SSL_CRLPATH; 添加于 8.0.23 (非保留字), SOURCE_SSL_KEY; 添加于 8.0.23 (非保留字), SOURCE_SSL_VERIFY_SERVER_CERT; 添加于 8.0.23 (非保留字), SOURCE_TLS_CIPHERSUITES; 添加于 8.0.23 (非保留字), SOURCE_TLS_VERSION; 添加于 8.0.23 (非保留字), SOURCE_USER; 添加于 8.0.23 (非保留字), SOURCE_ZSTD_COMPRESSION_LEVEL; 添加于 8.0.23 (非保留字), 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; 添加于 8.0.3 (非保留字), SSL (R), STACKED, START, STARTING (R), STARTS, STATS_AUTO_RECALC, STATS_PERSISTENT, STATS_SAMPLE_PAGES, STATUS, STOP, STORAGE, STORED (R), STRAIGHT_JOIN (R), STREAM; 添加于 8.0.20 (非保留字), STRING, SUBCLASS_ORIGIN, SUBJECT, SUBPARTITION, SUBPARTITIONS, SUPER, SUSPEND, SWAPS, SWITCHES, SYSTEM (R); 添加于 8.0.3 (保留字)
         
        T
        TABLE (R), TABLES, TABLESPACE, TABLE_CHECKSUM, TABLE_NAME, TEMPORARY, TEMPTABLE, TERMINATED (R), TEXT, THAN, THEN (R), THREAD_PRIORITY; 添加于 8.0.3 (非保留字), TIES; 添加于 8.0.2 (非保留字), TIME, TIMESTAMP, TIMESTAMPADD, TIMESTAMPDIFF, TINYBLOB (R), TINYINT (R), TINYTEXT (R), TLS; 添加于 8.0.21 (非保留字), TO (R), TRAILING (R), TRANSACTION, TRIGGER (R), TRIGGERS, TRUE (R), TRUNCATE, TYPE, TYPES
         
        U
        UNBOUNDED; 添加于 8.0.2 (非保留字), 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; 添加于 8.0.3 (非保留字), VIEW, VIRTUAL (R), VISIBLE
         
        W
        WAIT, WARNINGS, WEEK, WEIGHT_STRING, WHEN (R), WHERE (R), WHILE (R), WINDOW (R); 添加于 8.0.2 (保留字), WITH (R), WITHOUT, WORK, WRAPPER, WRITE (R)
         
        X
        X509, XA, XID, XML, XOR (R)
         
        Y
        YEAR, YEAR_MONTH (R)
         
        Z
        ZEROFILL (R), ZONE; 添加于 8.0.22 (非保留字)
         
        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, GET_SOURCE_PUBLIC_KEY, GROUPING (R), GROUPS (R)
         
        H
        HISTOGRAM, HISTORY
         
        I
        INACTIVE, 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, 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
         
        V
        VCPU, VISIBLE
         
        W
        WINDOW (R)
         
        Z
        ZONE
         
        MySQL 8.0 删除的关键字和保留字
         
        下表显示了与 MySQL 5.7 相比,MySQL 8.0 中删除的关键字和保留字。保留关键字用(R)标记。
         
        ANALYSE
         
        DES_KEY_FILE
         
        MASTER_SERVER_ID
         
        PARSE_GCOL_EXPR
         
        REDOFILE
         
        SQL_CACHE
         
         
         
         
        官方网址:
        https://dev.mysql.com/doc/refman/8.0/en/keywords.html
        文章转载自数据库杂货铺,如果涉嫌侵权,请发送邮件至:contact@modb.pro进行举报,并提供相关证据,一经查实,墨天轮将立刻删除相关内容。

        评论