本节提供有关 MySQL 5.7 中的关键字和保留字的信息。
以下列表显示了 MySQL 5.7 中的关键字和保留字,以及各个版本中对单个单词的更改。保留关键字用 (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; 在 5.7.6 中添加 (非保留字)ACTIONADD(R)AFTERAGAINSTAGGREGATEALGORITHMALL(R)ALTER(R)ALWAYS; 在 5.7.6 中添加 (非保留字)ANALYSEANALYZE(R)AND(R)ANYAS(R)ASC(R)ASCIIASENSITIVE(R)ATAUTOEXTEND_SIZEAUTO_INCREMENTAVGAVG_ROW_LENGTH
BACKUPBEFORE(R)BEGINBETWEEN(R)BIGINT(R)BINARY(R)BINLOGBITBLOB(R)BLOCKBOOLBOOLEANBOTH(R)BTREEBY(R)BYTE
CACHECALL(R)CASCADE(R)CASCADEDCASE(R)CATALOG_NAMECHAINCHANGE(R)CHANGEDCHANNEL; 在 5.7.6 中添加 (非保留字)CHAR(R)CHARACTER(R)CHARSETCHECK(R)CHECKSUMCIPHERCLASS_ORIGINCLIENTCLOSECOALESCECODECOLLATE(R)COLLATIONCOLUMN(R)COLUMNSCOLUMN_FORMATCOLUMN_NAMECOMMENTCOMMITCOMMITTEDCOMPACTCOMPLETIONCOMPRESSEDCOMPRESSION; 在 5.7.8 中添加 (非保留字)CONCURRENTCONDITION(R)CONNECTIONCONSISTENTCONSTRAINT(R)CONSTRAINT_CATALOGCONSTRAINT_NAMECONSTRAINT_SCHEMACONTAINSCONTEXTCONTINUE(R)CONVERT(R)CPUCREATE(R)CROSS(R)CUBECURRENTCURRENT_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_AUTHDEFINERDELAYED(R)DELAY_KEY_WRITEDELETE(R)DESC(R)DESCRIBE(R)DES_KEY_FILEDETERMINISTIC(R)DIAGNOSTICSDIRECTORYDISABLEDISCARDDISKDISTINCT(R)DISTINCTROW(R)DIV(R)DODOUBLE(R)DROP(R)DUAL(R)DUMPFILEDUPLICATEDYNAMIC
EACH(R)ELSE(R)ELSEIF(R)ENABLEENCLOSED(R)ENCRYPTION; 在 5.7.11 中添加 (非保留字)ENDENDSENGINEENGINESENUMERRORERRORSESCAPEESCAPED(R)EVENTEVENTSEVERYEXCHANGEEXECUTEEXISTS(R)EXIT(R)EXPANSIONEXPIREEXPLAIN(R)EXPORTEXTENDEDEXTENT_SIZE
FALSE(R)FASTFAULTSFETCH(R)FIELDSFILEFILE_BLOCK_SIZE; 在 5.7.6 中添加 (非保留字)FILTER; 在 5.7.3 中添加 (非保留字)FIRSTFIXEDFLOAT(R)FLOAT4(R)FLOAT8(R)FLUSHFOLLOWS; 在 5.7.2 中添加 (非保留字)FOR(R)FORCE(R)FOREIGN(R)FORMATFOUNDFROM(R)FULLFULLTEXT(R)FUNCTION
GENERALGENERATED(R); 在 5.7.6 中添加 (保留字)GEOMETRYGEOMETRYCOLLECTIONGET(R)GET_FORMATGLOBALGRANT(R)GRANTSGROUP(R)GROUP_REPLICATION; 在 5.7.6 中添加 (非保留字)
HANDLERHASHHAVING(R)HELPHIGH_PRIORITY(R)HOSTHOSTSHOURHOUR_MICROSECOND(R)HOUR_MINUTE(R)HOUR_SECOND(R)
IDENTIFIEDIF(R)IGNORE(R)IGNORE_SERVER_IDSIMPORTIN(R)INDEX(R)INDEXESINFILE(R)INITIAL_SIZEINNER(R)INOUT(R)INSENSITIVE(R)INSERT(R)INSERT_METHODINSTALLINSTANCE; 在 5.7.11 中添加 (非保留字)INT(R)INT1(R)INT2(R)INT3(R)INT4(R)INT8(R)INTEGER(R)INTERVAL(R)INTO(R)INVOKERIOIO_AFTER_GTIDS(R)IO_BEFORE_GTIDS(R)IO_THREADIPCIS(R)ISOLATIONISSUERITERATE(R)
JOIN(R)JSON; 在 5.7.8 中添加 (非保留字)
KEY(R)KEYS(R)KEY_BLOCK_SIZEKILL(R)
LANGUAGELASTLEADING(R)LEAVE(R)LEAVESLEFT(R)LESSLEVELLIKE(R)LIMIT(R)LINEAR(R)LINES(R)LINESTRINGLISTLOAD(R)LOCALLOCALTIME(R)LOCALTIMESTAMP(R)LOCK(R)LOCKSLOGFILELOGSLONG(R)LONGBLOB(R)LONGTEXT(R)LOOP(R)LOW_PRIORITY(R)
MASTERMASTER_AUTO_POSITIONMASTER_BIND(R)MASTER_CONNECT_RETRYMASTER_DELAYMASTER_HEARTBEAT_PERIODMASTER_HOSTMASTER_LOG_FILEMASTER_LOG_POSMASTER_PASSWORDMASTER_PORTMASTER_RETRY_COUNTMASTER_SERVER_IDMASTER_SSLMASTER_SSL_CAMASTER_SSL_CAPATHMASTER_SSL_CERTMASTER_SSL_CIPHERMASTER_SSL_CRLMASTER_SSL_CRLPATHMASTER_SSL_KEYMASTER_SSL_VERIFY_SERVER_CERT(R)MASTER_TLS_VERSION; 5.7.10 (非保留)MASTER_USERMATCH(R)MAXVALUE(R)MAX_CONNECTIONS_PER_HOURMAX_QUERIES_PER_HOURMAX_ROWSMAX_SIZEMAX_STATEMENT_TIME; 5.7.4 (非保留); 5.7.8MAX_UPDATES_PER_HOURMAX_USER_CONNECTIONSMEDIUMMEDIUMBLOB(R)MEDIUMINT(R)MEDIUMTEXT(R)MEMORYMERGEMESSAGE_TEXTMICROSECONDMIDDLEINT(R)MIGRATEMINUTEMINUTE_MICROSECOND(R)MINUTE_SECOND(R)MIN_ROWSMOD(R)MODEMODIFIES(R)MODIFYMONTHMULTILINESTRINGMULTIPOINTMULTIPOLYGONMUTEXMYSQL_ERRNO
NAMENAMESNATIONALNATURAL(R)NCHARNDBNDBCLUSTERNEVER; 5.7.4 (非保留)NEWNEXTNONODEGROUPNONBLOCKING; 5.7.6NONENOT(R)NO_WAITNO_WRITE_TO_BINLOG(R)NULL(R)NUMBERNUMERIC(R)NVARCHAR
OFFSETOLD_PASSWORD; 5.7.5ON(R)ONEONLYOPENOPTIMIZE(R)OPTIMIZER_COSTS(R); 5.7.5 (保留)OPTION(R)OPTIONALLY(R)OPTIONSOR(R)ORDER(R)OUT(R)OUTER(R)OUTFILE(R)OWNER
PACK_KEYSPAGEPARSERPARSE_GCOL_EXPR; 5.7.6 (保留); 5.7.8PARTIALPARTITION(R)PARTITIONINGPARTITIONSPASSWORDPHASEPLUGINPLUGINSPLUGIN_DIRPOINTPOLYGONPORTPRECEDES; 5.7.2 (非保留)PRECISION(R)PREPAREPRESERVEPREVPRIMARY(R)PRIVILEGESPROCEDURE(R)PROCESSLISTPROFILEPROFILESPROXYPURGE(R)
QUARTERQUERYQUICK
RANGE(R)READ(R)READS(R)READ_ONLYREAD_WRITE(R)REAL(R)REBUILDRECOVERREDOFILEREDO_BUFFER_SIZEREDUNDANTREFERENCES(R)REGEXP(R)RELAYRELAYLOGRELAY_LOG_FILERELAY_LOG_POSRELAY_THREADRELEASE(R)RELOADREMOVERENAME(R)REORGANIZEREPAIRREPEAT(R)REPEATABLEREPLACE(R)REPLICATE_DO_DB; 5.7.3 (非保留)REPLICATE_DO_TABLE; 5.7.3 (非保留)REPLICATE_IGNORE_DB; 5.7.3 (非保留)REPLICATE_IGNORE_TABLE; 5.7.3 (非保留)REPLICATE_REWRITE_DB; 5.7.3 (非保留)REPLICATE_WILD_DO_TABLE; 5.7.3 (非保留)REPLICATE_WILD_IGNORE_TABLE; 5.7.3 (非保留)REPLICATIONREQUIRE(R)RESETRESIGNAL(R)RESTORERESTRICT(R)RESUMERETURN(R)RETURNED_SQLSTATERETURNSREVERSEREVOKE(R)RIGHT(R)RLIKE(R)ROLLBACKROLLUPROTATE; 5.7.11 (非保留)ROUTINEROWROWSROW_COUNTROW_FORMATRTREE
SAVEPOINTSCHEDULESCHEMA(R)SCHEMAS(R)SCHEMA_NAMESECONDSECOND_MICROSECOND(R)SECURITYSELECT(R)SENSITIVE(R)SEPARATOR(R)SERIALSERIALIZABLESERVERSESSIONSET(R)SHARESHOW(R)SHUTDOWNSIGNAL(R)SIGNEDSIMPLESLAVESLOWSMALLINT(R)SNAPSHOTSOCKETSOMESONAMESOUNDSSOURCESPATIAL(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_CACHESQL_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_YEARSSL(R)STACKEDSTARTSTARTING(R)STARTSSTATS_AUTO_RECALCSTATS_PERSISTENTSTATS_SAMPLE_PAGESSTATUSSTOPSTORAGESTORED(R); 5.7.6 (保留)STRAIGHT_JOIN(R)STRINGSUBCLASS_ORIGINSUBJECTSUBPARTITIONSUBPARTITIONSSUPERSUSPENDSWAPSSWITCHES
TABLE(R)TABLESTABLESPACETABLE_CHECKSUMTABLE_NAMETEMPORARYTEMPTABLETERMINATED(R)TEXTTHANTHEN(R)TIMETIMESTAMPTIMESTAMPADDTIMESTAMPDIFFTINYBLOB(R)TINYINT(R)TINYTEXT(R)TO(R)TRAILING(R)TRANSACTIONTRIGGER(R)TRIGGERSTRUE(R)TRUNCATETYPETYPES
UNCOMMITTEDUNDEFINEDUNDO(R)UNDOFILEUNDO_BUFFER_SIZEUNICODEUNINSTALLUNION(R)UNIQUE(R)UNKNOWNUNLOCK(R)UNSIGNED(R)UNTILUPDATE(R)UPGRADEUSAGE(R)USE(R)USERUSER_RESOURCESUSE_FRMUSING(R)UTC_DATE(R)UTC_TIME(R)UTC_TIMESTAMP(R)
VALIDATION; 5.7.5 (非保留)VALUEVALUES(R)VARBINARY(R)VARCHAR(R)VARCHARACTER(R)VARIABLESVARYING(R)VIEWVIRTUAL(R); 5.7.6 (保留)
WAITWARNINGSWEEKWEIGHT_STRINGWHEN(R)WHERE(R)WHILE(R)WITH(R)WITHOUT; 5.7.5 (非保留)WORKWRAPPERWRITE(R)
X509XAXID; 5.7.5 (非保留)XMLXOR(R)
YEARYEAR_MONTH(R)
ZEROFILL(R)
以下列表显示了 MySQL 5.7 中新增的关键字和保留字,与 MySQL 5.6 相比。保留关键字用 (R) 标记。
A | C | E | F | G | I | J | M | N | O | P | R | S | V | W | X
ACCOUNTALWAYS
CHANNELCOMPRESSION
ENCRYPTION
FILE_BLOCK_SIZEFILTERFOLLOWS
GENERATED(R)GROUP_REPLICATION
INSTANCE
JSON
MASTER_TLS_VERSION
NEVER
OPTIMIZER_COSTS(R)
PARSE_GCOL_EXPRPRECEDES
REPLICATE_DO_DBREPLICATE_DO_TABLEREPLICATE_IGNORE_DBREPLICATE_IGNORE_TABLEREPLICATE_REWRITE_DBREPLICATE_WILD_DO_TABLEREPLICATE_WILD_IGNORE_TABLEROTATE
STACKEDSTORED(R)
VALIDATIONVIRTUAL(R)
WITHOUT
XID