本節提供關於 MySQL 8.2 中關鍵字和保留字的資訊。
以下清單顯示 MySQL 8.2 中的關鍵字和保留字,以及各版本中個別單字的變更。保留關鍵字以 (R) 標示。
A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z
ACCESSIBLE
(R)ACCOUNT
ACTION
ACTIVE
ADD
(R)ADMIN
AFTER
AGAINST
AGGREGATE
ALGORITHM
ALL
(R)ALTER
(R)ALWAYS
ANALYZE
(R)AND
(R)ANY
ARRAY
AS
(R)ASC
(R)ASCII
ASENSITIVE
(R)AT
ATTRIBUTE
AUTHENTICATION
AUTOEXTEND_SIZE
AUTO_INCREMENT
AVG
AVG_ROW_LENGTH
BACKUP
BEFORE
(R)BEGIN
BETWEEN
(R)BIGINT
(R)BINARY
(R)BINLOG
BIT
BLOB
(R)BLOCK
BOOL
BOOLEAN
BOTH
(R)BTREE
BUCKETS
BULK
BY
(R)BYTE
CACHE
CALL
(R)CASCADE
(R)CASCADED
CASE
(R)CATALOG_NAME
CHAIN
CHALLENGE_RESPONSE
CHANGE
(R)CHANGED
CHANNEL
CHAR
(R)CHARACTER
(R)CHARSET
CHECK
(R)CHECKSUM
CIPHER
CLASS_ORIGIN
CLIENT
CLONE
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)CUME_DIST
(R)CURRENT
CURRENT_DATE
(R)CURRENT_TIME
(R)CURRENT_TIMESTAMP
(R)CURRENT_USER
(R)CURSOR
(R)CURSOR_NAME
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
DELAYED
(R)DELAY_KEY_WRITE
DELETE
(R)DENSE_RANK
(R)DESC
(R)DESCRIBE
(R)DESCRIPTION
DETERMINISTIC
(R)DIAGNOSTICS
DIRECTORY
DISABLE
DISCARD
DISK
DISTINCT
(R)DISTINCTROW
(R)DIV
(R)DO
DOUBLE
(R)DROP
(R)DUAL
(R)DUMPFILE
DUPLICATE
DYNAMIC
EACH
(R)ELSE
(R)ELSEIF
(R)EMPTY
(R)ENABLE
ENCLOSED
(R)ENCRYPTION
END
ENDS
ENFORCED
ENGINE
ENGINES
ENGINE_ATTRIBUTE
ENUM
ERROR
ERRORS
ESCAPE
ESCAPED
(R)EVENT
EVENTS
EVERY
EXCEPT
(R)EXCHANGE
EXCLUDE
EXECUTE
EXISTS
(R)EXIT
(R)EXPANSION
EXPIRE
EXPLAIN
(R)EXPORT
EXTENDED
EXTENT_SIZE
FACTOR
FAILED_LOGIN_ATTEMPTS
FALSE
(R)FAST
FAULTS
FETCH
(R)FIELDS
FILE
FILE_BLOCK_SIZE
FILTER
FINISH
FIRST
FIRST_VALUE
(R)FIXED
FLOAT
(R)FLOAT4
(R)FLOAT8
(R)FLUSH
FOLLOWING
FOLLOWS
FOR
(R)FORCE
(R)FOREIGN
(R)FORMAT
FOUND
FROM
(R)FULL
FULLTEXT
(R)FUNCTION
(R)
GENERAL
GENERATE
GENERATED
(R)GEOMCOLLECTION
GEOMETRY
GEOMETRYCOLLECTION
GET
(R)GET_FORMAT
GET_MASTER_PUBLIC_KEY
GET_SOURCE_PUBLIC_KEY
GLOBAL
GRANT
(R)GRANTS
GROUP
(R)GROUPING
(R)GROUPS
(R)GROUP_REPLICATION
GTIDS
GTID_ONLY
HANDLER
HASH
HAVING
(R)HELP
HIGH_PRIORITY
(R)HISTOGRAM
HISTORY
HOST
HOSTS
HOUR
HOUR_MICROSECOND
(R)HOUR_MINUTE
(R)HOUR_SECOND
(R)
IDENTIFIED
IF
(R)IGNORE
(R)IGNORE_SERVER_IDS
IMPORT
IN
(R)INACTIVE
INDEX
(R)INDEXES
INFILE
(R)INITIAL
INITIAL_SIZE
INITIATE
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)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)JSON_VALUE
KEY
(R)金鑰環 (KEYRING)
KEYS
(R)金鑰區塊大小 (KEY_BLOCK_SIZE)
KILL
(R)
LAG
(R)語言 (LANGUAGE)
最後 (LAST)
LAST_VALUE
(R)LATERAL
(R)LEAD
(R)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)
鎖 (LOCKS)
日誌 (LOG)
日誌檔 (LOGFILE)
日誌 (LOGS)
LONG
(R)LONGBLOB
(R)LONGTEXT
(R)LOOP
(R)LOW_PRIORITY
(R)
主伺服器 (MASTER)
主伺服器自動位置 (MASTER_AUTO_POSITION)
MASTER_BIND
(R)主伺服器壓縮演算法 (MASTER_COMPRESSION_ALGORITHMS)
主伺服器連線重試 (MASTER_CONNECT_RETRY)
主伺服器延遲 (MASTER_DELAY)
主伺服器心跳週期 (MASTER_HEARTBEAT_PERIOD)
主伺服器主機 (MASTER_HOST)
主伺服器日誌檔 (MASTER_LOG_FILE)
主伺服器日誌位置 (MASTER_LOG_POS)
主伺服器密碼 (MASTER_PASSWORD)
主伺服器埠 (MASTER_PORT)
主伺服器公鑰路徑 (MASTER_PUBLIC_KEY_PATH)
主伺服器重試次數 (MASTER_RETRY_COUNT)
主伺服器 SSL (MASTER_SSL)
主伺服器 SSL CA (MASTER_SSL_CA)
主伺服器 SSL CAPATH (MASTER_SSL_CAPATH)
主伺服器 SSL 憑證 (MASTER_SSL_CERT)
主伺服器 SSL 密碼 (MASTER_SSL_CIPHER)
主伺服器 SSL CRL (MASTER_SSL_CRL)
主伺服器 SSL CRLPATH (MASTER_SSL_CRLPATH)
主伺服器 SSL 金鑰 (MASTER_SSL_KEY)
MASTER_SSL_VERIFY_SERVER_CERT
(R)主伺服器 TLS 密碼套件 (MASTER_TLS_CIPHERSUITES)
主伺服器 TLS 版本 (MASTER_TLS_VERSION)
主伺服器使用者 (MASTER_USER)
主伺服器 ZSTD 壓縮層級 (MASTER_ZSTD_COMPRESSION_LEVEL)
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)
記憶體 (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 錯誤代碼 (MYSQL_ERRNO)
名稱 (NAME)
名稱 (NAMES)
國家 (NATIONAL)
NATURAL
(R)NCHAR
NDB
NDBCLUSTER
巢狀 (NESTED)
網路命名空間 (NETWORK_NAMESPACE)
永不 (NEVER)
新增 (NEW)
下一個 (NEXT)
否 (NO)
節點群組 (NODEGROUP)
無 (NONE)
NOT
(R)不等待 (NOWAIT)
不等待 (NO_WAIT)
NO_WRITE_TO_BINLOG
(R)NTH_VALUE
(R)NTILE
(R)NULL
(R)空值 (NULLS)
數字 (NUMBER)
NUMERIC
(R)NVARCHAR
OF
(R)關閉 (OFF)
偏移 (OFFSET)
OJ
舊 (OLD)
ON
(R)一 (ONE)
僅 (ONLY)
開啟 (OPEN)
OPTIMIZE
(R)OPTIMIZER_COSTS
(R)OPTION
(R)可選 (OPTIONAL)
OPTIONALLY
(R)選項 (OPTIONS)
OR
(R)ORDER
(R)序數 (ORDINALITY)
組織 (ORGANIZATION)
其他 (OTHERS)
OUT
(R)OUTER
(R)OUTFILE
(R)OVER
(R)擁有者 (OWNER)
封裝金鑰 (PACK_KEYS)
頁面 (PAGE)
PARALLEL
(R)剖析器 (PARSER)
剖析樹 (PARSE_TREE)
部分 (PARTIAL)
PARTITION
(R)分割 (PARTITIONING)
分割區 (PARTITIONS)
密碼 (PASSWORD)
密碼鎖定時間 (PASSWORD_LOCK_TIME)
路徑 (PATH)
PERCENT_RANK
(R)持續 (PERSIST)
僅持續 (PERSIST_ONLY)
階段 (PHASE)
外掛程式 (PLUGIN)
外掛程式 (PLUGINS)
外掛程式目錄 (PLUGIN_DIR)
點 (POINT)
多邊形 (POLYGON)
埠 (PORT)
在...之前 (PRECEDES)
之前 (PRECEDING)
PRECISION
(R)準備 (PREPARE)
保留 (PRESERVE)
前一個 (PREV)
PRIMARY
(R)權限 (PRIVILEGES)
權限檢查使用者 (PRIVILEGE_CHECKS_USER)
PROCEDURE
(R)處理程序 (PROCESS)
處理程序清單 (PROCESSLIST)
設定檔 (PROFILE)
設定檔 (PROFILES)
代理 (PROXY)
PURGE
(R)
季 (QUARTER)
查詢 (QUERY)
快速 (QUICK)
隨機 (RANDOM)
RANGE
(R)RANK
(R)READ
(R)READS
(R)唯讀 (READ_ONLY)
READ_WRITE
(R)REAL
(R)重建 (REBUILD)
復原 (RECOVER)
RECURSIVE
(R)重做緩衝區大小 (REDO_BUFFER_SIZE)
冗餘 (REDUNDANT)
參考 (REFERENCE)
REFERENCES
(R)REGEXP
(R)註冊 (REGISTRATION)
中繼 (RELAY)
中繼日誌 (RELAYLOG)
中繼日誌檔 (RELAY_LOG_FILE)
中繼日誌位置 (RELAY_LOG_POS)
中繼執行緒 (RELAY_THREAD)
RELEASE
(R)重新載入 (RELOAD)
移除 (REMOVE)
RENAME
(R)重新組織 (REORGANIZE)
修復 (REPAIR)
REPEAT
(R)可重複 (REPEATABLE)
REPLACE
(R)複本 (REPLICA)
複本 (REPLICAS)
複寫執行資料庫 (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)
重設 (RESET)
RESIGNAL
(R)資源 (RESOURCE)
尊重 (RESPECT)
重新啟動 (RESTART)
還原 (RESTORE)
RESTRICT
(R)繼續 (RESUME)
保留 (RETAIN)
RETURN
(R)傳回的 SQLSTATE (RETURNED_SQLSTATE)
正在傳回 (RETURNING)
傳回 (RETURNS)
重用 (REUSE)
反轉 (REVERSE)
REVOKE
(R)RIGHT
(R)RLIKE
(R)角色 (ROLE)
回滾 (ROLLBACK)
總計 (ROLLUP)
輪換 (ROTATE)
常式 (ROUTINE)
ROW
(R)ROWS
(R)列數 (ROW_COUNT)
列格式 (ROW_FORMAT)
ROW_NUMBER
(R)RTREE
S3
儲存點 (SAVEPOINT)
排程 (SCHEDULE)
SCHEMA
(R)SCHEMAS
(R)綱要名稱 (SCHEMA_NAME)
秒 (SECOND)
次要 (SECONDARY)
次要引擎 (SECONDARY_ENGINE)
次要引擎屬性 (SECONDARY_ENGINE_ATTRIBUTE)
次要載入 (SECONDARY_LOAD)
次要卸載 (SECONDARY_UNLOAD)
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)
從屬 (SLAVE)
慢 (SLOW)
SMALLINT
(R)快照 (SNAPSHOT)
通訊端 (SOCKET)
某些 (SOME)
SONAME
聽起來像 (SOUNDS)
來源 (SOURCE)
來源自動位置 (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)
來源 SSL (SOURCE_SSL)
來源 SSL CA (SOURCE_SSL_CA)
來源 SSL CAPATH (SOURCE_SSL_CAPATH)
來源 SSL 憑證 (SOURCE_SSL_CERT)
來源 SSL 密碼 (SOURCE_SSL_CIPHER)
來源 SSL CRL (SOURCE_SSL_CRL)
來源 SSL CRLPATH (SOURCE_SSL_CRLPATH)
來源 SSL 金鑰 (SOURCE_SSL_KEY)
來源 SSL 驗證伺服器憑證 (SOURCE_SSL_VERIFY_SERVER_CERT)
來源 TLS 密碼套件 (SOURCE_TLS_CIPHERSUITES)
來源 TLS 版本 (SOURCE_TLS_VERSION)
來源使用者 (SOURCE_USER)
來源 ZSTD 壓縮層級 (SOURCE_ZSTD_COMPRESSION_LEVEL)
SPATIAL
(R)SPECIFIC
(R)SQL
(R)SQLEXCEPTION
(R)SQLSTATE
(R)SQLWARNING
(R)SQL 後 GTID (SQL_AFTER_GTIDS)
SQL 後 MTS 間隙 (SQL_AFTER_MTS_GAPS)
SQL 前 GTID (SQL_BEFORE_GTIDS)
SQL_BIG_RESULT
(R)SQL 緩衝結果 (SQL_BUFFER_RESULT)
SQL_CALC_FOUND_ROWS
(R)SQL 無快取 (SQL_NO_CACHE)
SQL_SMALL_RESULT
(R)SQL 執行緒 (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
SSL
(R)堆疊 (STACKED)
開始 (START)
STARTING
(R)開始 (STARTS)
統計資料自動重新計算 (STATS_AUTO_RECALC)
統計資料持久 (STATS_PERSISTENT)
統計資料取樣頁面 (STATS_SAMPLE_PAGES)
狀態 (STATUS)
停止 (STOP)
儲存 (STORAGE)
STORED
(R)STRAIGHT_JOIN
(R)串流 (STREAM)
字串 (STRING)
子類別來源 (SUBCLASS_ORIGIN)
主旨 (SUBJECT)
子分割區 (SUBPARTITION)
子分割區 (SUBPARTITIONS)
超級 (SUPER)
暫停 (SUSPEND)
交換 (SWAPS)
切換 (SWITCHES)
SYSTEM
(R)
TABLE
(R)資料表 (TABLES)
資料表空間 (TABLESPACE)
資料表檢查總和 (TABLE_CHECKSUM)
資料表名稱 (TABLE_NAME)
暫時 (TEMPORARY)
暫存資料表 (TEMPTABLE)
TERMINATED
(R)文字 (TEXT)
比 (THAN)
THEN
(R)執行緒優先權 (THREAD_PRIORITY)
並列 (TIES)
時間 (TIME)
時間戳記 (TIMESTAMP)
TIMESTAMPADD
TIMESTAMPDIFF
TINYBLOB
(R)TINYINT
(R)TINYTEXT
(R)TLS
TRAILING
(R)交易 (TRANSACTION)
TRIGGER
(R)觸發器 (TRIGGERS)
TRUE
(R)截斷 (TRUNCATE)
類型 (TYPE)
類型 (TYPES)
無界限 (UNBOUNDED)
未提交 (UNCOMMITTED)
未定義 (UNDEFINED)
UNDO
(R)復原檔 (UNDOFILE)
復原緩衝區大小 (UNDO_BUFFER_SIZE)
萬國碼 (UNICODE)
解除安裝 (UNINSTALL)
UNION
(R)UNIQUE
(R)未知 (UNKNOWN)
UNLOCK
(R)取消註冊 (UNREGISTER)
UNSIGNED
(R)直到 (UNTIL)
UPDATE
(R)升級 (UPGRADE)
網址 (URL)
USAGE
(R)USE
(R)使用者 (USER)
使用者資源 (USER_RESOURCES)
使用FRM (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)
檢視 (VIEW)
VIRTUAL
(R)可見 (VISIBLE)
等待 (WAIT)
警告 (WARNINGS)
週 (WEEK)
權重字串 (WEIGHT_STRING)
WHEN
(R)WHERE
(R)WHILE
(R)WINDOW
(R)WITH
(R)沒有 (WITHOUT)
工作 (WORK)
封裝器 (WRAPPER)
WRITE
(R)
X509
XA
XID
XML
XOR
(R)
年 (YEAR)
YEAR_MONTH
(R)
ZEROFILL
(R)時區 (ZONE)
下列列表顯示相較於 MySQL 8.1,在 MySQL 8.2 中新增的關鍵字與保留字。保留關鍵字以 (R) 標示。
GTIDS
日誌 (LOG)
PARALLEL
(R)S3