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
