关键字是在 SQL 中有意义的词。某些关键字(如 SELECT、DELETE 或 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 中的关键字和保留字,以及各个版本对单个关键字的更改。保留关键字用(R)标记。此外,_FILENAME 是保留字。在某个时候,可能会升级到更高版本,所以查看用于将来的保留字也是要考虑的。可以在涵盖 MySQL 更高版本的手册中找到这些。标准 SQL 禁止列表中的大多数保留字作为列或表名(例如,GROUP)。一些是保留字,因为 MySQL 需要它们,并且用于 yacc 解析器。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_LENGTHBACKUP, 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), BYTECACHE, 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_NAMEDATA, 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, DYNAMICEACH (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_SIZEFAILED_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 成为保留字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_REPLICATIONHANDLER, 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)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)JOIN (R), JSON, JSON_TABLE (R); 添加于 8.0.4 (保留字), JSON_VALUE; 添加于 8.0.21 (非保留字)KEY (R), KEYRING; 添加于 8.0.24 (非保留字), KEYS (R), KEY_BLOCK_SIZE, KILL (R)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)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_ERRNONAME, 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), NVARCHAROF (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 (保留字), OWNERPACK_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)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 (保留字), RTREESAVEPOINT, 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 (保留字)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, TYPESUNBOUNDED; 添加于 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)VALIDATION, VALUE, VALUES (R), VARBINARY (R), VARCHAR (R), VARCHARACTER (R), VARIABLES, VARYING (R), VCPU; 添加于 8.0.3 (非保留字), VIEW, VIRTUAL (R), VISIBLEWAIT, WARNINGS, WEEK, WEIGHT_STRING, WHEN (R), WHERE (R), WHILE (R), WINDOW (R); 添加于 8.0.2 (保留字), WITH (R), WITHOUT, WORK, WRAPPER, WRITE (R)X509, XA, XID, XML, XOR (R)ZEROFILL (R), ZONE; 添加于 8.0.22 (非保留字)下表显示了与 MySQL 5.7 相比,MySQL 8.0 中添加的关键字和保留字。保留关键字用(R)标记。ACTIVE, ADMIN, ARRAY, ATTRIBUTECLONE, COMPONENT, CUME_DIST (R)DEFINITION, DENSE_RANK (R), DESCRIPTIONEMPTY (R), ENFORCED, ENGINE_ATTRIBUTE, EXCEPT (R), EXCLUDEFAILED_LOGIN_ATTEMPTS, FIRST_VALUE (R), FOLLOWINGGEOMCOLLECTION, GET_MASTER_PUBLIC_KEY, GET_SOURCE_PUBLIC_KEY, GROUPING (R), GROUPS (R)JSON_TABLE (R), JSON_VALUELAG (R), LAST_VALUE (R), LATERAL (R), LEAD (R), LOCKEDMASTER_COMPRESSION_ALGORITHMS, MASTER_PUBLIC_KEY_PATH, MASTER_TLS_CIPHERSUITES, MASTER_ZSTD_COMPRESSION_LEVEL, MEMBERNESTED, NETWORK_NAMESPACE, NOWAIT, NTH_VALUE (R), NTILE (R), NULLSOF (R), OFF, OJ, OLD, OPTIONAL, ORDINALITY, ORGANIZATION, OTHERS, OVER (R)PASSWORD_LOCK_TIME, PATH, PERCENT_RANK (R), PERSIST, PERSIST_ONLY, PRECEDING, PRIVILEGE_CHECKS_USER, PROCESSRANDOM, RANK (R), RECURSIVE (R), REFERENCE, REPLICA, REPLICAS, REQUIRE_ROW_FORMAT, RESOURCE, RESPECT, RESTART, RETAIN, RETURNING, REUSE, ROLE, ROW_NUMBER (R)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)THREAD_PRIORITY, TIES, TLS下表显示了与 MySQL 5.7 相比,MySQL 8.0 中删除的关键字和保留字。保留关键字用(R)标记。https://dev.mysql.com/doc/refman/8.0/en/keywords.html