本節提供關於 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)ACCOUNTACTIONACTIVEADD(R)ADMINAFTERAGAINSTAGGREGATEALGORITHMALL(R)ALTER(R)ALWAYSANALYZE(R)AND(R)ANYARRAYAS(R)ASC(R)ASCIIASENSITIVE(R)ATATTRIBUTEAUTHENTICATIONAUTOAUTOEXTEND_SIZEAUTO_INCREMENTAVGAVG_ROW_LENGTH
BACKUPBEFORE(R)BEGINBERNOULLIBETWEEN(R)BIGINT(R)BINARY(R)BINLOGBITBLOB(R)BLOCKBOOLBOOLEANBOTH(R)BTREEBUCKETSBULKBY(R)BYTE
CACHECALL(R)CASCADE(R)CASCADEDCASE(R)CATALOG_NAMECHAINCHALLENGE_RESPONSECHANGE(R)CHANGEDCHANNELCHAR(R)CHARACTER(R)CHARSETCHECK(R)CHECKSUMCIPHERCLASS_ORIGINCLIENTCLONECLOSECOALESCECODECOLLATE(R)COLLATIONCOLUMN(R)COLUMNSCOLUMN_FORMATCOLUMN_NAMECOMMENTCOMMITCOMMITTEDCOMPACTCOMPLETIONCOMPONENTCOMPRESSEDCOMPRESSIONCONCURRENTCONDITION(R)CONNECTIONCONSISTENTCONSTRAINT(R)CONSTRAINT_CATALOGCONSTRAINT_NAMECONSTRAINT_SCHEMACONTAINSCONTEXTCONTINUE(R)CONVERT(R)CPUCREATE(R)CROSS(R)CUBE(R)CUME_DIST(R)CURRENTCURRENT_DATE(R)CURRENT_TIME(R)CURRENT_TIMESTAMP(R)CURRENT_USER(R)CURSOR(R)CURSOR_NAME
DATADATABASE(R)DATABASES(R)DATAFILEDATEDATETIMEDAYDAY_HOUR(R)DAY_MICROSECOND(R)DAY_MINUTE(R)DAY_SECOND(R)DEALLOCATEDEC(R)DECIMAL(R)DECLARE(R)DEFAULT(R)DEFAULT_AUTHDEFINERDEFINITIONDELAYED(R)DELAY_KEY_WRITEDELETE(R)DENSE_RANK(R)DESC(R)DESCRIBE(R)DESCRIPTIONDETERMINISTIC(R)DIAGNOSTICSDIRECTORYDISABLEDISCARDDISKDISTINCT(R)DISTINCTROW(R)DIV(R)DODOUBLE(R)DROP(R)DUAL(R)DUMPFILEDUPLICATEDYNAMIC
EACH(R)ELSE(R)ELSEIF(R)EMPTY(R)ENABLEENCLOSED(R)ENCRYPTIONENDENDSENFORCEDENGINEENGINESENGINE_ATTRIBUTEENUMERRORERRORSESCAPEESCAPED(R)EVENTEVENTSEVERYEXCEPT(R)EXCHANGEEXCLUDEEXECUTEEXISTS(R)EXIT(R)EXPANSIONEXPIREEXPLAIN(R)EXPORTEXTENDEDEXTENT_SIZE
FACTORFAILED_LOGIN_ATTEMPTSFALSE(R)FASTFAULTSFETCH(R)FIELDSFILEFILE_BLOCK_SIZEFILTERFINISHFIRSTFIRST_VALUE(R)FIXEDFLOAT(R)FLOAT4(R)FLOAT8(R)FLUSHFOLLOWINGFOLLOWSFOR(R)FORCE(R)FOREIGN(R)FORMATFOUNDFROM(R)FULLFULLTEXT(R)FUNCTION(R)
GENERALGENERATEGENERATED(R)GEOMCOLLECTIONGEOMETRYGEOMETRYCOLLECTIONGET(R)GET_FORMATGET_SOURCE_PUBLIC_KEYGLOBALGRANT(R)GRANTSGROUP(R)GROUPING(R)GROUPS(R)GROUP_REPLICATIONGTIDSGTID_ONLY
HANDLERHASHHAVING(R)HELPHIGH_PRIORITY(R)HISTOGRAMHISTORYHOSTHOSTSHOURHOUR_MICROSECOND(R)HOUR_MINUTE(R)HOUR_SECOND(R)
IDENTIFIEDIF(R)IGNORE(R)IGNORE_SERVER_IDSIMPORTIN(R)INACTIVEINDEX(R)INDEXESINFILE(R)INITIALINITIAL_SIZEINITIATEINNER(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_THREADIPCIS(R)隔離發行者ITERATE(R)
JOIN(R)JSONJSON_TABLE(R)JSON_VALUE
KEY(R)金鑰環KEYS(R)KEY_BLOCK_SIZEKILL(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)NCHARNDBNDBCLUSTER巢狀網路命名空間永不新的下一個否節點群組無NOT(R)不等待NO_WAITNO_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)程序處理程序清單設定檔設定檔ProxyPURGE(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_FILERELAY_LOG_POS中繼執行緒RELEASE(R)重新載入移除RENAME(R)重新組織修復REPEAT(R)可重複REPLACE(R)複本複本REPLICATE_DO_DBREPLICATE_DO_TABLEREPLICATE_IGNORE_DBREPLICATE_IGNORE_TABLEREPLICATE_REWRITE_DBREPLICATE_WILD_DO_TABLEREPLICATE_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_COUNTROW_FORMATROW_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_POSITIONSOURCE_BINDSOURCE_COMPRESSION_ALGORITHMSSOURCE_CONNECT_RETRY來源延遲SOURCE_HEARTBEAT_PERIODSOURCE_HOSTSOURCE_LOG_FILESOURCE_LOG_POSSOURCE_PASSWORDSOURCE_PORTSOURCE_PUBLIC_KEY_PATHSOURCE_RETRY_COUNTSOURCE_SSLSOURCE_SSL_CASOURCE_SSL_CAPATHSOURCE_SSL_CERTSOURCE_SSL_CIPHERSOURCE_SSL_CRLSOURCE_SSL_CRLPATHSOURCE_SSL_KEYSOURCE_SSL_VERIFY_SERVER_CERTSOURCE_TLS_CIPHERSUITESSOURCE_TLS_VERSIONSOURCE_USERSOURCE_ZSTD_COMPRESSION_LEVELSPATIAL(R)SPECIFIC(R)SQL(R)SQLEXCEPTION(R)SQLSTATE(R)SQLWARNING(R)SQL_AFTER_GTIDSSQL_AFTER_MTS_GAPSSQL_BEFORE_GTIDSSQL_BIG_RESULT(R)SQL_BUFFER_RESULTSQL_CALC_FOUND_ROWS(R)SQL_NO_CACHESQL_SMALL_RESULT(R)SQL_THREADSQL_TSI_DAYSQL_TSI_HOURSQL_TSI_MINUTESQL_TSI_MONTHSQL_TSI_QUARTERSQL_TSI_SECONDSQL_TSI_WEEKSQL_TSI_YEARSRIDSSL(R)堆疊開始STARTING(R)開始STATS_AUTO_RECALCSTATS_PERSISTENTSTATS_SAMPLE_PAGES狀態停止儲存STORED(R)STRAIGHT_JOIN(R)串流字串子類別來源主旨子分割區子分割區超級暫停交換切換SYSTEM(R)
TABLE(R)資料表TABLESAMPLE(R)表空間TABLE_CHECKSUMTABLE_NAME暫時暫存表TERMINATED(R)文字比THEN(R)執行緒優先權關係時間時間戳記TIMESTAMPADDTIMESTAMPDIFFTINYBLOB(R)TINYINT(R)TINYTEXT(R)TLSTO(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_FRMUSING(R)UTC_DATE(R)UTC_TIME(R)UTC_TIMESTAMP(R)
驗證值VALUES(R)VARBINARY(R)VARCHAR(R)VARCHARACTER(R)變數VARYING(R)VCPU檢視VIRTUAL(R)VISIBLE
WAITWARNINGSWEEKWEIGHT_STRINGWHEN(R)WHERE(R)WHILE(R)WINDOW(R)WITH(R)WITHOUTWORKWRAPPERWRITE(R)
X509XAXIDXMLXOR(R)
YEARYEAR_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_POSITIONMASTER_BIND(R)MASTER_COMPRESSION_ALGORITHMSMASTER_CONNECT_RETRYMASTER_DELAYMASTER_HEARTBEAT_PERIODMASTER_HOSTMASTER_LOG_FILEMASTER_LOG_POSMASTER_PASSWORDMASTER_PORTMASTER_PUBLIC_KEY_PATHMASTER_RETRY_COUNTMASTER_SSLMASTER_SSL_CAMASTER_SSL_CAPATHMASTER_SSL_CERTMASTER_SSL_CIPHERMASTER_SSL_CRLMASTER_SSL_CRLPATHMASTER_SSL_KEYMASTER_SSL_VERIFY_SERVER_CERT(R)MASTER_TLS_CIPHERSUITESMASTER_TLS_VERSIONMASTER_USERMASTER_ZSTD_COMPRESSION_LEVEL