本節提供關於 MySQL 8.4 中關鍵字和保留字的資訊。
以下列表顯示 MySQL 8.4 中的關鍵字和保留字,以及各版本之間個別單字的變更。保留關鍵字標記為 (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
AUTO
AUTOEXTEND_SIZE
AUTO_INCREMENT
AVG
AVG_ROW_LENGTH
BACKUP
BEFORE
(R)BEGIN
BERNOULLI
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_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
安裝
實例
INT
(R)INT1
(R)INT2
(R)INT3
(R)INT4
(R)INT8
(R)INTEGER
(R)INTERSECT
(R)INTERVAL
(R)INTO
(R)不可見的
調用者
輸入/輸出
IO_AFTER_GTIDS
(R)IO_BEFORE_GTIDS
(R)IO_THREAD
IPC
IS
(R)隔離
發行者
ITERATE
(R)
JOIN
(R)JSON
JSON_TABLE
(R)JSON_VALUE
KEY
(R)金鑰環
KEYS
(R)KEY_BLOCK_SIZE
KILL
(R)
LAG
(R)語言
最後
LAST_VALUE
(R)LATERAL
(R)LEAD
(R)LEADING
(R)LEAVE
(R)葉
LEFT
(R)較少
級別
LIKE
(R)LIMIT
(R)LINEAR
(R)LINES
(R)線字串
列表
LOAD
(R)本地
LOCALTIME
(R)LOCALTIMESTAMP
(R)LOCK
(R)已鎖定
鎖
日誌
日誌檔
日誌
LONG
(R)LONGBLOB
(R)LONGTEXT
(R)LOOP
(R)LOW_PRIORITY
(R)
MANUAL
(R)主機
MATCH
(R)MAXVALUE
(R)每小時最大連線數
每小時最大查詢數
最大列數
最大大小
每小時最大更新次數
最大使用者連線數
中等
MEDIUMBLOB
(R)MEDIUMINT
(R)MEDIUMTEXT
(R)成員
記憶體
合併
訊息文字
微秒
MIDDLEINT
(R)移轉
分鐘
MINUTE_MICROSECOND
(R)MINUTE_SECOND
(R)最小列數
MOD
(R)模式
MODIFIES
(R)修改
月份
多線字串
多點
多邊形
互斥
MYSQL_ERRNO
名稱
名稱
國家
NATURAL
(R)NCHAR
NDB
NDBCLUSTER
巢狀
網路命名空間
永不
新的
下一個
否
節點群組
無
NOT
(R)不等待
NO_WAIT
NO_WRITE_TO_BINLOG
(R)NTH_VALUE
(R)NTILE
(R)NULL
(R)空值
數字
NUMERIC
(R)NVARCHAR
OF
(R)關閉
偏移
OJ
舊的
ON
(R)一
僅
開啟
OPTIMIZE
(R)OPTIMIZER_COSTS
(R)OPTION
(R)可選
OPTIONALLY
(R)選項
OR
(R)ORDER
(R)序數
組織
其他
OUT
(R)OUTER
(R)OUTFILE
(R)OVER
(R)擁有者
PACK_KEYS
頁面
PARALLEL
(R)剖析器
剖析樹
部分
PARTITION
(R)分割
分割區
密碼
密碼鎖定時間
路徑
PERCENT_RANK
(R)持續
僅持續
階段
外掛程式
外掛程式
PLUGIN_DIR
點
多邊形
連接埠
優先
在先
PRECISION
(R)準備
保留
上一個
PRIMARY
(R)權限
權限檢查使用者
PROCEDURE
(R)程序
處理程序清單
設定檔
設定檔
Proxy
PURGE
(R)
QUALIFY
(R)季度
查詢
快速
隨機
RANGE
(R)RANK
(R)READ
(R)READS
(R)唯讀
READ_WRITE
(R)REAL
(R)重建
復原
RECURSIVE
(R)REDO_BUFFER_SIZE
多餘
參考
REFERENCES
(R)REGEXP
(R)註冊
中繼
中繼日誌
RELAY_LOG_FILE
RELAY_LOG_POS
中繼執行緒
RELEASE
(R)重新載入
移除
RENAME
(R)重新組織
修復
REPEAT
(R)可重複
REPLACE
(R)複本
複本
REPLICATE_DO_DB
REPLICATE_DO_TABLE
REPLICATE_IGNORE_DB
REPLICATE_IGNORE_TABLE
REPLICATE_REWRITE_DB
REPLICATE_WILD_DO_TABLE
REPLICATE_WILD_IGNORE_TABLE
複寫
REQUIRE
(R)REQUIRE_ROW_FORMAT
重設
RESIGNAL
(R)資源
尊重
重新啟動
還原
RESTRICT
(R)繼續
保留
RETURN
(R)RETURNED_SQLSTATE
傳回
傳回
重複使用
反向
REVOKE
(R)RIGHT
(R)RLIKE
(R)角色
回滾
總計
旋轉
常式
ROW
(R)ROWS
(R)ROW_COUNT
ROW_FORMAT
ROW_NUMBER
(R)RTREE
S3
儲存點
排程
SCHEMA
(R)SCHEMAS
(R)SCHEMA_NAME
秒
次要
次要引擎
次要引擎屬性
次要載入
次要卸載
SECOND_MICROSECOND
(R)安全性
SELECT
(R)SENSITIVE
(R)SEPARATOR
(R)串列
可序列化
伺服器
工作階段
SET
(R)分享
SHOW
(R)關機
SIGNAL
(R)已簽署
簡單
跳過
從屬
慢速
SMALLINT
(R)快照
通訊端
某些
SONAME
發聲
來源
SOURCE_AUTO_POSITION
SOURCE_BIND
SOURCE_COMPRESSION_ALGORITHMS
SOURCE_CONNECT_RETRY
來源延遲
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
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_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
SSL
(R)堆疊
開始
STARTING
(R)開始
STATS_AUTO_RECALC
STATS_PERSISTENT
STATS_SAMPLE_PAGES
狀態
停止
儲存
STORED
(R)STRAIGHT_JOIN
(R)串流
字串
子類別來源
主旨
子分割區
子分割區
超級
暫停
交換
切換
SYSTEM
(R)
TABLE
(R)資料表
TABLESAMPLE
(R)表空間
TABLE_CHECKSUM
TABLE_NAME
暫時
暫存表
TERMINATED
(R)文字
比
THEN
(R)執行緒優先權
關係
時間
時間戳記
TIMESTAMPADD
TIMESTAMPDIFF
TINYBLOB
(R)TINYINT
(R)TINYTEXT
(R)TLS
TO
(R)TRAILING
(R)交易
TRIGGER
(R)觸發器
TRUE
(R)截斷
類型
類型
無界限
未提交
未定義
UNDO
(R)復原檔
UNDO_BUFFER_SIZE
萬國碼
解除安裝
UNION
(R)UNIQUE
(R)未知
UNLOCK
(R)取消註冊
UNSIGNED
(R)直到
UPDATE
(R)升級
網址
USAGE
(R)USE
(R)使用者
使用者資源
USE_FRM
USING
(R)UTC_DATE
(R)UTC_TIME
(R)UTC_TIMESTAMP
(R)
驗證
值
VALUES
(R)VARBINARY
(R)VARCHAR
(R)VARCHARACTER
(R)變數
VARYING
(R)VCPU
檢視
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.0 相比,MySQL 8.4 中新增的關鍵字和保留字。保留字以 (R) 標記。
A | B | G | L | M | P | Q | S | T
AUTO
BERNOULLI
GTIDS
日誌
MANUAL
(R)
PARALLEL
(R)剖析樹
QUALIFY
(R)
S3
TABLESAMPLE
(R)
以下列表顯示與 MySQL 8.0 相比,MySQL 8.4 中移除的關鍵字和保留字。保留字以 (R) 標記。
GET_MASTER_PUBLIC_KEY
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
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
MASTER_TLS_VERSION
MASTER_USER
MASTER_ZSTD_COMPRESSION_LEVEL