MySQL保留字
短信预约 -IT技能 免费直播动态提醒
MySQL保留字
MySQL中的保留字和Java中的保留字一样，在命名时不能使用保留字，所以对于MySQL中的保留字要有个大概的印象，下文自https://dev.mysql.com/doc/refman/5.7/en/keywords.html#获取，如有需要可以到官网查看详情。
以下列表显示了My SQL 5.7中的关键字和保留单词，以及不同版本对单个单词的更改。保留关键字用（R）标记。此外，保留FILENAME。
在某些时候，您可能会升级到更高的版本，因此，查看未来的保留字也是一个好主意。您可以在包含更高版本My SQL的手册中找到这些。标准SQL禁止列表中的大多数保留字作为列或表名（例如，GROUP）。保留了一些，因为我的SQL需要它们并使用yacc解析器。
A
ACCESSIBLE®ACCOUNT; added in 5.7.6 (nonreserved)ACTIONADD®AFTERAGAINSTAGGREGATEALGORITHMALL®ALTER®ALWAYS; added in 5.7.6 (nonreserved)ANALYSEANALYZE®AND®ANYAS®ASC®ASCIIASENSITIVE®ATAUTOEXTEND_SIZEAUTO_INCREMENTAVGAVG_ROW_LENGTH
B
BACKUPBEFORE®BEGINBETWEEN®BIGINT®BINARY®BINLOGBITBLOB®BLOCKBOOLBOOLEANBOTH®BTREEBY®BYTE
C
CACHECALL®CASCADE®CASCADEDCASE®CATALOG_NAMECHAINCHANGE®CHANGEDCHANNEL; added in 5.7.6 (nonreserved)CHAR®CHARACTER®CHARSETCHECK®CHECKSUMCIPHERCLASS_ORIGINCLIENTCLOSECOALESCECODECOLLATE®COLLATIONCOLUMN®COLUMNSCOLUMN_FORMATCOLUMN_NAMECOMMENTCOMMITCOMMITTEDCOMPACTCOMPLETIONCOMPRESSEDCOMPRESSION; added in 5.7.8 (nonreserved)CONCURRENTCONDITION®CONNECTIONCONSISTENTCONSTRAINT®CONSTRAINT_CATALOGCONSTRAINT_NAMECONSTRAINT_SCHEMACONTAINSCONTEXTCONTINUE®CONVERT®CPUCREATE®CROSS®CUBECURRENTCURRENT_DATE®CURRENT_TIME®CURRENT_TIMESTAMP®CURRENT_USER®CURSOR®CURSOR_NAME
D
DATADATABASE®DATABASES®DATAFILEDATEDATETIMEDAYDAY_HOUR®DAY_MICROSECOND®DAY_MINUTE®DAY_SECOND®DEALLOCATEDEC®DECIMAL®DECLARE®DEFAULT®DEFAULT_AUTHDEFINERDELAYED®DELAY_KEY_WRITEDELETE®DESC®DESCRIBE®DES_KEY_FILEDETERMINISTIC®DIAGNOSTICSDIRECTORYDISABLEDISCARDDISKDISTINCT®DISTINCTROW®DIV®DODOUBLE®DROP®DUAL®DUMPFILEDUPLICATEDYNAMIC
E
EACH®ELSE®ELSEIF®ENABLEENCLOSED®ENCRYPTION; added in 5.7.11 (nonreserved)ENDENDSENGINEENGINESENUMERRORERRORSESCAPEESCAPED®EVENTEVENTSEVERYEXCHANGEEXECUTEEXISTS®EXIT®EXPANSIONEXPIREEXPLAIN®EXPORTEXTENDEDEXTENT_SIZE
F
FALSE®FASTFAULTSFETCH®FIELDSFILEFILE_BLOCK_SIZE; added in 5.7.6 (nonreserved)FILTER; added in 5.7.3 (nonreserved)FIRSTFIXEDFLOAT®FLOAT4®FLOAT8®FLUSHFOLLOWS; added in 5.7.2 (nonreserved)FOR®FORCE®FOREIGN®FORMATFOUNDFROM®FULLFULLTEXT®FUNCTION
G
GENERALGENERATED®; added in 5.7.6 (reserved)GEOMETRYGEOMETRYCOLLECTIONGET®GET_FORMATGLOBALGRANT®GRANTSGROUP®GROUP_REPLICATION; added in 5.7.6 (nonreserved)
H
HANDLERHASHHAVING®HELPHIGH_PRIORITY®HOSTHOSTSHOURHOUR_MICROSECOND®HOUR_MINUTE®HOUR_SECOND®
I
IDENTIFIEDIF®IGNORE®IGNORE_SERVER_IDSIMPORTIN®INDEX®INDEXESINFILE®INITIAL_SIZEINNER®INOUT®INSENSITIVE®INSERT®INSERT_METHODINSTALLINSTANCE; added in 5.7.11 (nonreserved)INT®INT1®INT2®INT3®INT4®INT8®INTEGER®INTERVAL®INTO®INVOKERIOIO_AFTER_GTIDS®IO_BEFORE_GTIDS®IO_THREADIPCIS®ISOLATIONISSUERITERATE®
J
JOIN®JSON; added in 5.7.8 (nonreserved)
K
KEY®KEYS®KEY_BLOCK_SIZEKILL®
L
LANGUAGELASTLEADING®LEAVE®LEAVESLEFT®LESSLEVELLIKE®LIMIT®LINEAR®LINES®LINESTRINGLISTLOAD®LOCALLOCALTIME®LOCALTIMESTAMP®LOCK®LOCKSLOGFILELOGSLONG®LONGBLOB®LONGTEXT®LOOP®LOW_PRIORITY®
M
MASTERMASTER_AUTO_POSITIONMASTER_BIND®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®MASTER_TLS_VERSION; added in 5.7.10 (nonreserved)MASTER_USERMATCH®MAXVALUE®MAX_CONNECTIONS_PER_HOURMAX_QUERIES_PER_HOURMAX_ROWSMAX_SIZEMAX_STATEMENT_TIME; added in 5.7.4 (nonreserved); removed in 5.7.8MAX_UPDATES_PER_HOURMAX_USER_CONNECTIONSMEDIUMMEDIUMBLOB®MEDIUMINT®MEDIUMTEXT®MEMORYMERGEMESSAGE_TEXTMICROSECONDMIDDLEINT®MIGRATEMINUTEMINUTE_MICROSECOND®MINUTE_SECOND®MIN_ROWSMOD®MODEMODIFIES®MODIFYMONTHMULTILINESTRINGMULTIPOINTMULTIPOLYGONMUTEXMYSQL_ERRNO
N
NAMENAMESNATIONALNATURAL®NCHARNDBNDBCLUSTERNEVER; added in 5.7.4 (nonreserved)NEWNEXTNONODEGROUPNONBLOCKING; removed in 5.7.6NONENOT®NO_WAITNO_WRITE_TO_BINLOG®NULL®NUMBERNUMERIC®NVARCHAR
O
OFFSETOLD_PASSWORD; removed in 5.7.5ON®ONEONLYOPENOPTIMIZE®OPTIMIZER_COSTS®; added in 5.7.5 (reserved)OPTION®OPTIONALLY®OPTIONSOR®ORDER®OUT®OUTER®OUTFILE®OWNER
P
PACK_KEYSPAGEPARSERPARSE_GCOL_EXPR; added in 5.7.6 (reserved); became nonreserved in 5.7.8PARTIALPARTITION®PARTITIONINGPARTITIONSPASSWORDPHASEPLUGINPLUGINSPLUGIN_DIRPOINTPOLYGONPORTPRECEDES; added in 5.7.2 (nonreserved)PRECISION®PREPAREPRESERVEPREVPRIMARY®PRIVILEGESPROCEDURE®PROCESSLISTPROFILEPROFILESPROXYPURGE®
Q
QUARTERQUERYQUICK
R
RANGE®READ®READS®READ_ONLYREAD_WRITE®REAL®REBUILDRECOVERREDOFILEREDO_BUFFER_SIZEREDUNDANTREFERENCES®REGEXP®RELAYRELAYLOGRELAY_LOG_FILERELAY_LOG_POSRELAY_THREADRELEASE®RELOADREMOVERENAME®REORGANIZEREPAIRREPEAT®REPEATABLEREPLACE®REPLICATE_DO_DB; added in 5.7.3 (nonreserved)REPLICATE_DO_TABLE; added in 5.7.3 (nonreserved)REPLICATE_IGNORE_DB; added in 5.7.3 (nonreserved)REPLICATE_IGNORE_TABLE; added in 5.7.3 (nonreserved)REPLICATE_REWRITE_DB; added in 5.7.3 (nonreserved)REPLICATE_WILD_DO_TABLE; added in 5.7.3 (nonreserved)REPLICATE_WILD_IGNORE_TABLE; added in 5.7.3 (nonreserved)REPLICATIONREQUIRE®RESETRESIGNAL®RESTORERESTRICT®RESUMERETURN®RETURNED_SQLSTATERETURNSREVERSEREVOKE®RIGHT®RLIKE®ROLLBACKROLLUPROTATE; added in 5.7.11 (nonreserved)ROUTINEROWROWSROW_COUNTROW_FORMATRTREE
S
SAVEPOINTSCHEDULESCHEMA®SCHEMAS®SCHEMA_NAMESECONDSECOND_MICROSECOND®SECURITYSELECT®SENSITIVE®SEPARATOR®SERIALSERIALIZABLESERVERSESSIONSET®SHARESHOW®SHUTDOWNSIGNAL®SIGNEDSIMPLESLAVESLOWSMALLINT®SNAPSHOTSOCKETSOMESONAMESOUNDSSOURCESPATIAL®SPECIFIC®SQL®SQLEXCEPTION®SQLSTATE®SQLWARNING®SQL_AFTER_GTIDSSQL_AFTER_MTS_GAPSSQL_BEFORE_GTIDSSQL_BIG_RESULT®SQL_BUFFER_RESULTSQL_CACHESQL_CALC_FOUND_ROWS®SQL_NO_CACHESQL_SMALL_RESULT®SQL_THREADSQL_TSI_DAYSQL_TSI_HOURSQL_TSI_MINUTESQL_TSI_MONTHSQL_TSI_QUARTERSQL_TSI_SECONDSQL_TSI_WEEKSQL_TSI_YEARSSL®STACKEDSTARTSTARTING®STARTSSTATS_AUTO_RECALCSTATS_PERSISTENTSTATS_SAMPLE_PAGESSTATUSSTOPSTORAGESTORED®; added in 5.7.6 (reserved)STRAIGHT_JOIN®STRINGSUBCLASS_ORIGINSUBJECTSUBPARTITIONSUBPARTITIONSSUPERSUSPENDSWAPSSWITCHES
T
TABLE®TABLESTABLESPACETABLE_CHECKSUMTABLE_NAMETEMPORARYTEMPTABLETERMINATED®TEXTTHANTHEN®TIMETIMESTAMPTIMESTAMPADDTIMESTAMPDIFFTINYBLOB®TINYINT®TINYTEXT®TO®TRAILING®TRANSACTIONTRIGGER®TRIGGERSTRUE®TRUNCATETYPETYPES
U
UNCOMMITTEDUNDEFINEDUNDO®UNDOFILEUNDO_BUFFER_SIZEUNICODEUNINSTALLUNION®UNIQUE®UNKNOWNUNLOCK®UNSIGNED®UNTILUPDATE®UPGRADEUSAGE®USE®USERUSER_RESOURCESUSE_FRMUSING®UTC_DATE®UTC_TIME®UTC_TIMESTAMP®
V
VALIDATION; added in 5.7.5 (nonreserved)VALUEVALUES®VARBINARY®VARCHAR®VARCHARACTER®VARIABLESVARYING®VIEWVIRTUAL®; added in 5.7.6 (reserved)
W
WAITWARNINGSWEEKWEIGHT_STRINGWHEN®WHERE®WHILE®WITH®WITHOUT; added in 5.7.5 (nonreserved)WORKWRAPPERWRITE®
X
X509XAXID; added in 5.7.5 (nonreserved)XMLXOR®
Y
YEARYEAR_MONTH®
Z
ZEROFILL®
MySQL 5.7 New Keywords and Reserved Words
The following list shows the keywords and reserved words that are added in MySQL 5.7, compared to MySQL 5.6. Reserved keywords are marked with ®.
A | C | E | F | G | I | J | M | N | O | P | R | S | V | W | X
A
ACCOUNTALWAYS
C
CHANNELCOMPRESSION
E
ENCRYPTION
F
FILE_BLOCK_SIZEFILTERFOLLOWS
G
GENERATED®GROUP_REPLICATION
I
INSTANCE
J
JSON
M
MASTER_TLS_VERSION
N
NEVER
O
OPTIMIZER_COSTS®
P
PARSE_GCOL_EXPRPRECEDES
R
REPLICATE_DO_DBREPLICATE_DO_TABLEREPLICATE_IGNORE_DBREPLICATE_IGNORE_TABLEREPLICATE_REWRITE_DBREPLICATE_WILD_DO_TABLEREPLICATE_WILD_IGNORE_TABLEROTATE
S
STACKEDSTORED®
V
VALIDATIONVIRTUAL®
W
WITHOUT
X
XID
来源地址：https://blog.csdn.net/qq_45464872/article/details/128390225
免责声明：
① 本站未注明“稿件来源”的信息均来自网络整理。其文字、图片和音视频稿件的所属权归原作者所有。本站收集整理出于非商业性的教育和科研之目的，并不意味着本站赞同其观点或证实其内容的真实性。仅作为临时的测试数据，供内部测试之用。本站并未授权任何人以任何方式主动获取本站任何信息。
② 本站未注明“稿件来源”的临时测试数据将在测试完成后最终做删除处理。有问题或投稿请发送至: 邮箱/279061341@qq.com QQ/279061341
![[mysql]mysql8修改root密码](https://static.528045.com/imgs/41.jpg?imageMogr2/format/webp/blur/1x0/quality/35)
