MySQL保留字不能作为字段名使用_Table字段不能设为关键字range，range在mysql中是分区,是mysql的关键字

本是古典何须时尚 2023-09-30 13:34 19阅读 0赞

> mysql 中Table字段不能设为关键字range，range在mysql中是分区,是mysql的关键字

在设计MySQL字段的时候，无意中使用InOut这个名称作为字段名称，结果前端提交后就是没有写入数据库！但后端没有任何提示，跟踪mySQL日志，也没有留下痕迹，反复查，不得其解。 后来实在没有办法情况下，之后把表删除，重新手动建一次表，就在再次建表的时候，灵光一现，可能就出在InOut这个名字上，于是改为In\_Out，果不出其然，一切OK。 原因是InOut是mySQL的保留字，不能作为字段名。

MySQL保留字如下：

**Table 9.2 Keywords and Reserved Words in MySQL 5.7**

<table> 
 <thead> 
  <tr> 
   <th><code>ACCESSIBLE</code> ®</th> 
   <th><code>ACCOUNT</code>[<a href="https://dev.mysql.com/doc/refman/5.7/en/keywords.html#ftn.idm140312823595472" rel="nofollow">a]</a></th> 
   <th><code>ACTION</code></th> 
  </tr> 
 </thead> 
 <tbody> 
  <tr> 
   <td><code>ADD</code> ®</td> 
   <td><code>AFTER</code></td> 
   <td><code>AGAINST</code></td> 
  </tr> 
  <tr> 
   <td><code>AGGREGATE</code></td> 
   <td><code>ALGORITHM</code></td> 
   <td><code>ALL</code> ®</td> 
  </tr> 
  <tr> 
   <td><code>ALTER</code> ®</td> 
   <td><code>ALWAYS</code>[<a href="https://dev.mysql.com/doc/refman/5.7/en/keywords.html#ftn.idm140312823581632" rel="nofollow">b]</a></td> 
   <td><code>ANALYSE</code></td> 
  </tr> 
  <tr> 
   <td><code>ANALYZE</code> ®</td> 
   <td><code>AND</code> ®</td> 
   <td><code>ANY</code></td> 
  </tr> 
  <tr> 
   <td><code>AS</code> ®</td> 
   <td><code>ASC</code> ®</td> 
   <td><code>ASCII</code></td> 
  </tr> 
  <tr> 
   <td><code>ASENSITIVE</code> ®</td> 
   <td><code>AT</code></td> 
   <td><code>AUTOEXTEND_SIZE</code></td> 
  </tr> 
  <tr> 
   <td><code>AUTO_INCREMENT</code></td> 
   <td><code>AVG</code></td> 
   <td><code>AVG_ROW_LENGTH</code></td> 
  </tr> 
  <tr> 
   <td><code>BACKUP</code></td> 
   <td><code>BEFORE</code> ®</td> 
   <td><code>BEGIN</code></td> 
  </tr> 
  <tr> 
   <td><code>BETWEEN</code> ®</td> 
   <td><code>BIGINT</code> ®</td> 
   <td><code>BINARY</code> ®</td> 
  </tr> 
  <tr> 
   <td><code>BINLOG</code></td> 
   <td><code>BIT</code></td> 
   <td><code>BLOB</code> ®</td> 
  </tr> 
  <tr> 
   <td><code>BLOCK</code></td> 
   <td><code>BOOL</code></td> 
   <td><code>BOOLEAN</code></td> 
  </tr> 
  <tr> 
   <td><code>BOTH</code> ®</td> 
   <td><code>BTREE</code></td> 
   <td><code>BY</code> ®</td> 
  </tr> 
  <tr> 
   <td><code>BYTE</code></td> 
   <td><code>CACHE</code></td> 
   <td><code>CALL</code> ®</td> 
  </tr> 
  <tr> 
   <td><code>CASCADE</code> ®</td> 
   <td><code>CASCADED</code></td> 
   <td><code>CASE</code> ®</td> 
  </tr> 
  <tr> 
   <td><code>CATALOG_NAME</code></td> 
   <td><code>CHAIN</code></td> 
   <td><code>CHANGE</code> ®</td> 
  </tr> 
  <tr> 
   <td><code>CHANGED</code></td> 
   <td><code>CHANNEL</code>[<a href="https://dev.mysql.com/doc/refman/5.7/en/keywords.html#ftn.idm140312823524320" rel="nofollow">c]</a></td> 
   <td><code>CHAR</code> ®</td> 
  </tr> 
  <tr> 
   <td><code>CHARACTER</code> ®</td> 
   <td><code>CHARSET</code></td> 
   <td><code>CHECK</code> ®</td> 
  </tr> 
  <tr> 
   <td><code>CHECKSUM</code></td> 
   <td><code>CIPHER</code></td> 
   <td><code>CLASS_ORIGIN</code></td> 
  </tr> 
  <tr> 
   <td><code>CLIENT</code></td> 
   <td><code>CLOSE</code></td> 
   <td><code>COALESCE</code></td> 
  </tr> 
  <tr> 
   <td><code>CODE</code></td> 
   <td><code>COLLATE</code> ®</td> 
   <td><code>COLLATION</code></td> 
  </tr> 
  <tr> 
   <td><code>COLUMN</code> ®</td> 
   <td><code>COLUMNS</code></td> 
   <td><code>COLUMN_FORMAT</code></td> 
  </tr> 
  <tr> 
   <td><code>COLUMN_NAME</code></td> 
   <td><code>COMMENT</code></td> 
   <td><code>COMMIT</code></td> 
  </tr> 
  <tr> 
   <td><code>COMMITTED</code></td> 
   <td><code>COMPACT</code></td> 
   <td><code>COMPLETION</code></td> 
  </tr> 
  <tr> 
   <td><code>COMPRESSED</code></td> 
   <td><code>COMPRESSION</code>[<a href="https://dev.mysql.com/doc/refman/5.7/en/keywords.html#ftn.idm140312823489376" rel="nofollow">d]</a></td> 
   <td><code>CONCURRENT</code></td> 
  </tr> 
  <tr> 
   <td><code>CONDITION</code> ®</td> 
   <td><code>CONNECTION</code></td> 
   <td><code>CONSISTENT</code></td> 
  </tr> 
  <tr> 
   <td><code>CONSTRAINT</code> ®</td> 
   <td><code>CONSTRAINT_CATALOG</code></td> 
   <td><code>CONSTRAINT_NAME</code></td> 
  </tr> 
  <tr> 
   <td><code>CONSTRAINT_SCHEMA</code></td> 
   <td><code>CONTAINS</code></td> 
   <td><code>CONTEXT</code></td> 
  </tr> 
  <tr> 
   <td><code>CONTINUE</code> ®</td> 
   <td><code>CONVERT</code> ®</td> 
   <td><code>CPU</code></td> 
  </tr> 
  <tr> 
   <td><code>CREATE</code> ®</td> 
   <td><code>CROSS</code> ®</td> 
   <td><code>CUBE</code></td> 
  </tr> 
  <tr> 
   <td><code>CURRENT</code></td> 
   <td><code>CURRENT_DATE</code> ®</td> 
   <td><code>CURRENT_TIME</code> ®</td> 
  </tr> 
  <tr> 
   <td><code>CURRENT_TIMESTAMP</code> ®</td> 
   <td><code>CURRENT_USER</code> ®</td> 
   <td><code>CURSOR</code> ®</td> 
  </tr> 
  <tr> 
   <td><code>CURSOR_NAME</code></td> 
   <td><code>DATA</code></td> 
   <td><code>DATABASE</code> ®</td> 
  </tr> 
  <tr> 
   <td><code>DATABASES</code> ®</td> 
   <td><code>DATAFILE</code></td> 
   <td><code>DATE</code></td> 
  </tr> 
  <tr> 
   <td><code>DATETIME</code></td> 
   <td><code>DAY</code></td> 
   <td><code>DAY_HOUR</code> ®</td> 
  </tr> 
  <tr> 
   <td><code>DAY_MICROSECOND</code> ®</td> 
   <td><code>DAY_MINUTE</code> ®</td> 
   <td><code>DAY_SECOND</code> ®</td> 
  </tr> 
  <tr> 
   <td><code>DEALLOCATE</code></td> 
   <td><code>DEC</code> ®</td> 
   <td><code>DECIMAL</code> ®</td> 
  </tr> 
  <tr> 
   <td><code>DECLARE</code> ®</td> 
   <td><code>DEFAULT</code> ®</td> 
   <td><code>DEFAULT_AUTH</code></td> 
  </tr> 
  <tr> 
   <td><code>DEFINER</code></td> 
   <td><code>DELAYED</code> ®</td> 
   <td><code>DELAY_KEY_WRITE</code></td> 
  </tr> 
  <tr> 
   <td><code>DELETE</code> ®</td> 
   <td><code>DESC</code> ®</td> 
   <td><code>DESCRIBE</code> ®</td> 
  </tr> 
  <tr> 
   <td><code>DES_KEY_FILE</code></td> 
   <td><code>DETERMINISTIC</code> ®</td> 
   <td><code>DIAGNOSTICS</code></td> 
  </tr> 
  <tr> 
   <td><code>DIRECTORY</code></td> 
   <td><code>DISABLE</code></td> 
   <td><code>DISCARD</code></td> 
  </tr> 
  <tr> 
   <td><code>DISK</code></td> 
   <td><code>DISTINCT</code> ®</td> 
   <td><code>DISTINCTROW</code> ®</td> 
  </tr> 
  <tr> 
   <td><code>DIV</code> ®</td> 
   <td><code>DO</code></td> 
   <td><code>DOUBLE</code> ®</td> 
  </tr> 
  <tr> 
   <td><code>DROP</code> ®</td> 
   <td><code>DUAL</code> ®</td> 
   <td><code>DUMPFILE</code></td> 
  </tr> 
  <tr> 
   <td><code>DUPLICATE</code></td> 
   <td><code>DYNAMIC</code></td> 
   <td><code>EACH</code> ®</td> 
  </tr> 
  <tr> 
   <td><code>ELSE</code> ®</td> 
   <td><code>ELSEIF</code> ®</td> 
   <td><code>ENABLE</code></td> 
  </tr> 
  <tr> 
   <td><code>ENCLOSED</code> ®</td> 
   <td><code>ENCRYPTION</code>[<a href="https://dev.mysql.com/doc/refman/5.7/en/keywords.html#ftn.idm140312823387376" rel="nofollow">e]</a></td> 
   <td><code>END</code></td> 
  </tr> 
  <tr> 
   <td><code>ENDS</code></td> 
   <td><code>ENGINE</code></td> 
   <td><code>ENGINES</code></td> 
  </tr> 
  <tr> 
   <td><code>ENUM</code></td> 
   <td><code>ERROR</code></td> 
   <td><code>ERRORS</code></td> 
  </tr> 
  <tr> 
   <td><code>ESCAPE</code></td> 
   <td><code>ESCAPED</code> ®</td> 
   <td><code>EVENT</code></td> 
  </tr> 
  <tr> 
   <td><code>EVENTS</code></td> 
   <td><code>EVERY</code></td> 
   <td><code>EXCHANGE</code></td> 
  </tr> 
  <tr> 
   <td><code>EXECUTE</code></td> 
   <td><code>EXISTS</code> ®</td> 
   <td><code>EXIT</code> ®</td> 
  </tr> 
  <tr> 
   <td><code>EXPANSION</code></td> 
   <td><code>EXPIRE</code></td> 
   <td><code>EXPLAIN</code> ®</td> 
  </tr> 
  <tr> 
   <td><code>EXPORT</code></td> 
   <td><code>EXTENDED</code></td> 
   <td><code>EXTENT_SIZE</code></td> 
  </tr> 
  <tr> 
   <td><code>FALSE</code> ®</td> 
   <td><code>FAST</code></td> 
   <td><code>FAULTS</code></td> 
  </tr> 
  <tr> 
   <td><code>FETCH</code> ®</td> 
   <td><code>FIELDS</code></td> 
   <td><code>FILE</code></td> 
  </tr> 
  <tr> 
   <td><code>FILE_BLOCK_SIZE</code>[<a href="https://dev.mysql.com/doc/refman/5.7/en/keywords.html#ftn.idm140312823345312" rel="nofollow">f]</a></td> 
   <td><code>FILTER</code>[<a href="https://dev.mysql.com/doc/refman/5.7/en/keywords.html#ftn.idm140312823343024" rel="nofollow">g]</a></td> 
   <td><code>FIRST</code></td> 
  </tr> 
  <tr> 
   <td><code>FIXED</code></td> 
   <td><code>FLOAT</code> ®</td> 
   <td><code>FLOAT4</code> ®</td> 
  </tr> 
  <tr> 
   <td><code>FLOAT8</code> ®</td> 
   <td><code>FLUSH</code></td> 
   <td><code>FOLLOWS</code>[<a href="https://dev.mysql.com/doc/refman/5.7/en/keywords.html#ftn.idm140312823331968" rel="nofollow">h]</a></td> 
  </tr> 
  <tr> 
   <td><code>FOR</code> ®</td> 
   <td><code>FORCE</code> ®</td> 
   <td><code>FOREIGN</code> ®</td> 
  </tr> 
  <tr> 
   <td><code>FORMAT</code></td> 
   <td><code>FOUND</code></td> 
   <td><code>FROM</code> ®</td> 
  </tr> 
  <tr> 
   <td><code>FULL</code></td> 
   <td><code>FULLTEXT</code> ®</td> 
   <td><code>FUNCTION</code></td> 
  </tr> 
  <tr> 
   <td><code>GENERAL</code></td> 
   <td><code>GENERATED</code>[<a href="https://dev.mysql.com/doc/refman/5.7/en/keywords.html#ftn.idm140312823314928" rel="nofollow">i]</a> ®</td> 
   <td><code>GEOMETRY</code></td> 
  </tr> 
  <tr> 
   <td><code>GEOMETRYCOLLECTION</code></td> 
   <td><code>GET</code> ®</td> 
   <td><code>GET_FORMAT</code></td> 
  </tr> 
  <tr> 
   <td><code>GLOBAL</code></td> 
   <td><code>GRANT</code> ®</td> 
   <td><code>GRANTS</code></td> 
  </tr> 
  <tr> 
   <td><code>GROUP</code> ®</td> 
   <td><code>GROUP_REPLICATION</code>[<a href="https://dev.mysql.com/doc/refman/5.7/en/keywords.html#ftn.idm140312823300848" rel="nofollow">j]</a></td> 
   <td><code>HANDLER</code></td> 
  </tr> 
  <tr> 
   <td><code>HASH</code></td> 
   <td><code>HAVING</code> ®</td> 
   <td><code>HELP</code></td> 
  </tr> 
  <tr> 
   <td><code>HIGH_PRIORITY</code> ®</td> 
   <td><code>HOST</code></td> 
   <td><code>HOSTS</code></td> 
  </tr> 
  <tr> 
   <td><code>HOUR</code></td> 
   <td><code>HOUR_MICROSECOND</code> ®</td> 
   <td><code>HOUR_MINUTE</code> ®</td> 
  </tr> 
  <tr> 
   <td><code>HOUR_SECOND</code> ®</td> 
   <td><code>IDENTIFIED</code></td> 
   <td><code>IF</code> ®</td> 
  </tr> 
  <tr> 
   <td><code>IGNORE</code> ®</td> 
   <td><code>IGNORE_SERVER_IDS</code></td> 
   <td><code>IMPORT</code></td> 
  </tr> 
  <tr> 
   <td><code>IN</code> ®</td> 
   <td><code>INDEX</code> ®</td> 
   <td><code>INDEXES</code></td> 
  </tr> 
  <tr> 
   <td><code>INFILE</code> ®</td> 
   <td><code>INITIAL_SIZE</code></td> 
   <td><code>INNER</code> ®</td> 
  </tr> 
  <tr> 
   <td><code>INOUT</code> ®</td> 
   <td><code>INSENSITIVE</code> ®</td> 
   <td><code>INSERT</code> ®</td> 
  </tr> 
  <tr> 
   <td><code>INSERT_METHOD</code></td> 
   <td><code>INSTALL</code></td> 
   <td><code>INSTANCE</code>[<a href="https://dev.mysql.com/doc/refman/5.7/en/keywords.html#ftn.idm140312823259088" rel="nofollow">k]</a></td> 
  </tr> 
  <tr> 
   <td><code>INT</code> ®</td> 
   <td><code>INT1</code> ®</td> 
   <td><code>INT2</code> ®</td> 
  </tr> 
  <tr> 
   <td><code>INT3</code> ®</td> 
   <td><code>INT4</code> ®</td> 
   <td><code>INT8</code> ®</td> 
  </tr> 
  <tr> 
   <td><code>INTEGER</code> ®</td> 
   <td><code>INTERVAL</code> ®</td> 
   <td><code>INTO</code> ®</td> 
  </tr> 
  <tr> 
   <td><code>INVOKER</code></td> 
   <td><code>IO</code></td> 
   <td><code>IO_AFTER_GTIDS</code> ®</td> 
  </tr> 
  <tr> 
   <td><code>IO_BEFORE_GTIDS</code> ®</td> 
   <td><code>IO_THREAD</code></td> 
   <td><code>IPC</code></td> 
  </tr> 
  <tr> 
   <td><code>IS</code> ®</td> 
   <td><code>ISOLATION</code></td> 
   <td><code>ISSUER</code></td> 
  </tr> 
  <tr> 
   <td><code>ITERATE</code> ®</td> 
   <td><code>JOIN</code> ®</td> 
   <td><code>JSON</code>[<a href="https://dev.mysql.com/doc/refman/5.7/en/keywords.html#ftn.idm140312823226832" rel="nofollow">l]</a></td> 
  </tr> 
  <tr> 
   <td><code>KEY</code> ®</td> 
   <td><code>KEYS</code> ®</td> 
   <td><code>KEY_BLOCK_SIZE</code></td> 
  </tr> 
  <tr> 
   <td><code>KILL</code> ®</td> 
   <td><code>LANGUAGE</code></td> 
   <td><code>LAST</code></td> 
  </tr> 
  <tr> 
   <td><code>LEADING</code> ®</td> 
   <td><code>LEAVE</code> ®</td> 
   <td><code>LEAVES</code></td> 
  </tr> 
  <tr> 
   <td><code>LEFT</code> ®</td> 
   <td><code>LESS</code></td> 
   <td><code>LEVEL</code></td> 
  </tr> 
  <tr> 
   <td><code>LIKE</code> ®</td> 
   <td><code>LIMIT</code> ®</td> 
   <td><code>LINEAR</code> ®</td> 
  </tr> 
  <tr> 
   <td><code>LINES</code> ®</td> 
   <td><code>LINESTRING</code></td> 
   <td><code>LIST</code></td> 
  </tr> 
  <tr> 
   <td><code>LOAD</code> ®</td> 
   <td><code>LOCAL</code></td> 
   <td><code>LOCALTIME</code> ®</td> 
  </tr> 
  <tr> 
   <td><code>LOCALTIMESTAMP</code> ®</td> 
   <td><code>LOCK</code> ®</td> 
   <td><code>LOCKS</code></td> 
  </tr> 
  <tr> 
   <td><code>LOGFILE</code></td> 
   <td><code>LOGS</code></td> 
   <td><code>LONG</code> ®</td> 
  </tr> 
  <tr> 
   <td><code>LONGBLOB</code> ®</td> 
   <td><code>LONGTEXT</code> ®</td> 
   <td><code>LOOP</code> ®</td> 
  </tr> 
  <tr> 
   <td><code>LOW_PRIORITY</code> ®</td> 
   <td><code>MASTER</code></td> 
   <td><code>MASTER_AUTO_POSITION</code></td> 
  </tr> 
  <tr> 
   <td><code>MASTER_BIND</code> ®</td> 
   <td><code>MASTER_CONNECT_RETRY</code></td> 
   <td><code>MASTER_DELAY</code></td> 
  </tr> 
  <tr> 
   <td><code>MASTER_HEARTBEAT_PERIOD</code></td> 
   <td><code>MASTER_HOST</code></td> 
   <td><code>MASTER_LOG_FILE</code></td> 
  </tr> 
  <tr> 
   <td><code>MASTER_LOG_POS</code></td> 
   <td><code>MASTER_PASSWORD</code></td> 
   <td><code>MASTER_PORT</code></td> 
  </tr> 
  <tr> 
   <td><code>MASTER_RETRY_COUNT</code></td> 
   <td><code>MASTER_SERVER_ID</code></td> 
   <td><code>MASTER_SSL</code></td> 
  </tr> 
  <tr> 
   <td><code>MASTER_SSL_CA</code></td> 
   <td><code>MASTER_SSL_CAPATH</code></td> 
   <td><code>MASTER_SSL_CERT</code></td> 
  </tr> 
  <tr> 
   <td><code>MASTER_SSL_CIPHER</code></td> 
   <td><code>MASTER_SSL_CRL</code></td> 
   <td><code>MASTER_SSL_CRLPATH</code></td> 
  </tr> 
  <tr> 
   <td><code>MASTER_SSL_KEY</code></td> 
   <td><code>MASTER_SSL_VERIFY_SERVER_CERT</code> ®</td> 
   <td><code>MASTER_TLS_VERSION</code>[<a href="https://dev.mysql.com/doc/refman/5.7/en/keywords.html#ftn.idm140312823147904" rel="nofollow">m]</a></td> 
  </tr> 
  <tr> 
   <td><code>MASTER_USER</code></td> 
   <td><code>MATCH</code> ®</td> 
   <td><code>MAXVALUE</code> ®</td> 
  </tr> 
  <tr> 
   <td><code>MAX_CONNECTIONS_PER_HOUR</code></td> 
   <td><code>MAX_QUERIES_PER_HOUR</code></td> 
   <td><code>MAX_ROWS</code></td> 
  </tr> 
  <tr> 
   <td><code>MAX_SIZE</code></td> 
   <td><code>MAX_STATEMENT_TIME</code>[<a href="https://dev.mysql.com/doc/refman/5.7/en/keywords.html#ftn.idm140312823135440" rel="nofollow">n]</a></td> 
   <td><code>MAX_UPDATES_PER_HOUR</code></td> 
  </tr> 
  <tr> 
   <td><code>MAX_USER_CONNECTIONS</code></td> 
   <td><code>MEDIUM</code></td> 
   <td><code>MEDIUMBLOB</code> ®</td> 
  </tr> 
  <tr> 
   <td><code>MEDIUMINT</code> ®</td> 
   <td><code>MEDIUMTEXT</code> ®</td> 
   <td><code>MEMORY</code></td> 
  </tr> 
  <tr> 
   <td><code>MERGE</code></td> 
   <td><code>MESSAGE_TEXT</code></td> 
   <td><code>MICROSECOND</code></td> 
  </tr> 
  <tr> 
   <td><code>MIDDLEINT</code> ®</td> 
   <td><code>MIGRATE</code></td> 
   <td><code>MINUTE</code></td> 
  </tr> 
  <tr> 
   <td><code>MINUTE_MICROSECOND</code> ®</td> 
   <td><code>MINUTE_SECOND</code> ®</td> 
   <td><code>MIN_ROWS</code></td> 
  </tr> 
  <tr> 
   <td><code>MOD</code> ®</td> 
   <td><code>MODE</code></td> 
   <td><code>MODIFIES</code> ®</td> 
  </tr> 
  <tr> 
   <td><code>MODIFY</code></td> 
   <td><code>MONTH</code></td> 
   <td><code>MULTILINESTRING</code></td> 
  </tr> 
  <tr> 
   <td><code>MULTIPOINT</code></td> 
   <td><code>MULTIPOLYGON</code></td> 
   <td><code>MUTEX</code></td> 
  </tr> 
  <tr> 
   <td><code>MYSQL_ERRNO</code></td> 
   <td><code>NAME</code></td> 
   <td><code>NAMES</code></td> 
  </tr> 
  <tr> 
   <td><code>NATIONAL</code></td> 
   <td><code>NATURAL</code> ®</td> 
   <td><code>NCHAR</code></td> 
  </tr> 
  <tr> 
   <td><code>NDB</code></td> 
   <td><code>NDBCLUSTER</code></td> 
   <td><code>NEVER</code>[<a href="https://dev.mysql.com/doc/refman/5.7/en/keywords.html#ftn.idm140312823086176" rel="nofollow">o]</a></td> 
  </tr> 
  <tr> 
   <td><code>NEW</code></td> 
   <td><code>NEXT</code></td> 
   <td><code>NO</code></td> 
  </tr> 
  <tr> 
   <td><code>NODEGROUP</code></td> 
   <td><code>NONBLOCKING</code>[<a href="https://dev.mysql.com/doc/refman/5.7/en/keywords.html#ftn.idm140312823078256" rel="nofollow">p]</a></td> 
   <td><code>NONE</code></td> 
  </tr> 
  <tr> 
   <td><code>NOT</code> ®</td> 
   <td><code>NO_WAIT</code></td> 
   <td><code>NO_WRITE_TO_BINLOG</code> ®</td> 
  </tr> 
  <tr> 
   <td><code>NULL</code> ®</td> 
   <td><code>NUMBER</code></td> 
   <td><code>NUMERIC</code> ®</td> 
  </tr> 
  <tr> 
   <td><code>NVARCHAR</code></td> 
   <td><code>OFFSET</code></td> 
   <td><code>OLD_PASSWORD</code>[<a href="https://dev.mysql.com/doc/refman/5.7/en/keywords.html#ftn.idm140312823062944" rel="nofollow">q]</a></td> 
  </tr> 
  <tr> 
   <td><code>ON</code> ®</td> 
   <td><code>ONE</code></td> 
   <td><code>ONLY</code></td> 
  </tr> 
  <tr> 
   <td><code>OPEN</code></td> 
   <td><code>OPTIMIZE</code> ®</td> 
   <td><code>OPTIMIZER_COSTS</code>[<a href="https://dev.mysql.com/doc/refman/5.7/en/keywords.html#ftn.idm140312823053376" rel="nofollow">r]</a> ®</td> 
  </tr> 
  <tr> 
   <td><code>OPTION</code> ®</td> 
   <td><code>OPTIONALLY</code> ®</td> 
   <td><code>OPTIONS</code></td> 
  </tr> 
  <tr> 
   <td><code>OR</code> ®</td> 
   <td><code>ORDER</code> ®</td> 
   <td><code>OUT</code> ®</td> 
  </tr> 
  <tr> 
   <td><code>OUTER</code> ®</td> 
   <td><code>OUTFILE</code> ®</td> 
   <td><code>OWNER</code></td> 
  </tr> 
  <tr> 
   <td><code>PACK_KEYS</code></td> 
   <td><code>PAGE</code></td> 
   <td><code>PARSER</code></td> 
  </tr> 
  <tr> 
   <td><code>PARSE_GCOL_EXPR</code>[<a href="https://dev.mysql.com/doc/refman/5.7/en/keywords.html#ftn.idm140312823033040" rel="nofollow">s]</a></td> 
   <td><code>PARTIAL</code></td> 
   <td><code>PARTITION</code> ®</td> 
  </tr> 
  <tr> 
   <td><code>PARTITIONING</code></td> 
   <td><code>PARTITIONS</code></td> 
   <td><code>PASSWORD</code></td> 
  </tr> 
  <tr> 
   <td><code>PHASE</code></td> 
   <td><code>PLUGIN</code></td> 
   <td><code>PLUGINS</code></td> 
  </tr> 
  <tr> 
   <td><code>PLUGIN_DIR</code></td> 
   <td><code>POINT</code></td> 
   <td><code>POLYGON</code></td> 
  </tr> 
  <tr> 
   <td><code>PORT</code></td> 
   <td><code>PRECEDES</code>[<a href="https://dev.mysql.com/doc/refman/5.7/en/keywords.html#ftn.idm140312823013984" rel="nofollow">t]</a></td> 
   <td><code>PRECISION</code> ®</td> 
  </tr> 
  <tr> 
   <td><code>PREPARE</code></td> 
   <td><code>PRESERVE</code></td> 
   <td><code>PREV</code></td> 
  </tr> 
  <tr> 
   <td><code>PRIMARY</code> ®</td> 
   <td><code>PRIVILEGES</code></td> 
   <td><code>PROCEDURE</code> ®</td> 
  </tr> 
  <tr> 
   <td><code>PROCESSLIST</code></td> 
   <td><code>PROFILE</code></td> 
   <td><code>PROFILES</code></td> 
  </tr> 
  <tr> 
   <td><code>PROXY</code></td> 
   <td><code>PURGE</code> ®</td> 
   <td><code>QUARTER</code></td> 
  </tr> 
  <tr> 
   <td><code>QUERY</code></td> 
   <td><code>QUICK</code></td> 
   <td><code>RANGE</code> ®</td> 
  </tr> 
  <tr> 
   <td><code>READ</code> ®</td> 
   <td><code>READS</code> ®</td> 
   <td><code>READ_ONLY</code></td> 
  </tr> 
  <tr> 
   <td><code>READ_WRITE</code> ®</td> 
   <td><code>REAL</code> ®</td> 
   <td><code>REBUILD</code></td> 
  </tr> 
  <tr> 
   <td><code>RECOVER</code></td> 
   <td><code>REDOFILE</code></td> 
   <td><code>REDO_BUFFER_SIZE</code></td> 
  </tr> 
  <tr> 
   <td><code>REDUNDANT</code></td> 
   <td><code>REFERENCES</code> ®</td> 
   <td><code>REGEXP</code> ®</td> 
  </tr> 
  <tr> 
   <td><code>RELAY</code></td> 
   <td><code>RELAYLOG</code></td> 
   <td><code>RELAY_LOG_FILE</code></td> 
  </tr> 
  <tr> 
   <td><code>RELAY_LOG_POS</code></td> 
   <td><code>RELAY_THREAD</code></td> 
   <td><code>RELEASE</code> ®</td> 
  </tr> 
  <tr> 
   <td><code>RELOAD</code></td> 
   <td><code>REMOVE</code></td> 
   <td><code>RENAME</code> ®</td> 
  </tr> 
  <tr> 
   <td><code>REORGANIZE</code></td> 
   <td><code>REPAIR</code></td> 
   <td><code>REPEAT</code> ®</td> 
  </tr> 
  <tr> 
   <td><code>REPEATABLE</code></td> 
   <td><code>REPLACE</code> ®</td> 
   <td><code>REPLICATE_DO_DB</code>[<a href="https://dev.mysql.com/doc/refman/5.7/en/keywords.html#ftn.idm140312822951280" rel="nofollow">u]</a></td> 
  </tr> 
  <tr> 
   <td><code>REPLICATE_DO_TABLE</code>[<a href="https://dev.mysql.com/doc/refman/5.7/en/keywords.html#ftn.idm140312822948736" rel="nofollow">v]</a></td> 
   <td><code>REPLICATE_IGNORE_DB</code>[<a href="https://dev.mysql.com/doc/refman/5.7/en/keywords.html#ftn.idm140312822946448" rel="nofollow">w]</a></td> 
   <td><code>REPLICATE_IGNORE_TABLE</code>[<a href="https://dev.mysql.com/doc/refman/5.7/en/keywords.html#ftn.idm140312822944160" rel="nofollow">x]</a></td> 
  </tr> 
  <tr> 
   <td><code>REPLICATE_REWRITE_DB</code>[<a href="https://dev.mysql.com/doc/refman/5.7/en/keywords.html#ftn.idm140312822941616" rel="nofollow">y]</a></td> 
   <td><code>REPLICATE_WILD_DO_TABLE</code>[<a href="https://dev.mysql.com/doc/refman/5.7/en/keywords.html#ftn.idm140312822939328" rel="nofollow">z]</a></td> 
   <td><code>REPLICATE_WILD_IGNORE_TABLE</code>[<a href="https://dev.mysql.com/doc/refman/5.7/en/keywords.html#ftn.idm140312822937024" rel="nofollow">aa]</a></td> 
  </tr> 
  <tr> 
   <td><code>REPLICATION</code></td> 
   <td><code>REQUIRE</code> ®</td> 
   <td><code>RESET</code></td> 
  </tr> 
  <tr> 
   <td><code>RESIGNAL</code> ®</td> 
   <td><code>RESTORE</code></td> 
   <td><code>RESTRICT</code> ®</td> 
  </tr> 
  <tr> 
   <td><code>RESUME</code></td> 
   <td><code>RETURN</code> ®</td> 
   <td><code>RETURNED_SQLSTATE</code></td> 
  </tr> 
  <tr> 
   <td><code>RETURNS</code></td> 
   <td><code>REVERSE</code></td> 
   <td><code>REVOKE</code> ®</td> 
  </tr> 
  <tr> 
   <td><code>RIGHT</code> ®</td> 
   <td><code>RLIKE</code> ®</td> 
   <td><code>ROLLBACK</code></td> 
  </tr> 
  <tr> 
   <td><code>ROLLUP</code></td> 
   <td><code>ROTATE</code>[<a href="https://dev.mysql.com/doc/refman/5.7/en/keywords.html#ftn.idm140312822911328" rel="nofollow">ab]</a></td> 
   <td><code>ROUTINE</code></td> 
  </tr> 
  <tr> 
   <td><code>ROW</code></td> 
   <td><code>ROWS</code></td> 
   <td><code>ROW_COUNT</code></td> 
  </tr> 
  <tr> 
   <td><code>ROW_FORMAT</code></td> 
   <td><code>RTREE</code></td> 
   <td><code>SAVEPOINT</code></td> 
  </tr> 
  <tr> 
   <td><code>SCHEDULE</code></td> 
   <td><code>SCHEMA</code> ®</td> 
   <td><code>SCHEMAS</code> ®</td> 
  </tr> 
  <tr> 
   <td><code>SCHEMA_NAME</code></td> 
   <td><code>SECOND</code></td> 
   <td><code>SECOND_MICROSECOND</code> ®</td> 
  </tr> 
  <tr> 
   <td><code>SECURITY</code></td> 
   <td><code>SELECT</code> ®</td> 
   <td><code>SENSITIVE</code> ®</td> 
  </tr> 
  <tr> 
   <td><code>SEPARATOR</code> ®</td> 
   <td><code>SERIAL</code></td> 
   <td><code>SERIALIZABLE</code></td> 
  </tr> 
  <tr> 
   <td><code>SERVER</code></td> 
   <td><code>SESSION</code></td> 
   <td><code>SET</code> ®</td> 
  </tr> 
  <tr> 
   <td><code>SHARE</code></td> 
   <td><code>SHOW</code> ®</td> 
   <td><code>SHUTDOWN</code></td> 
  </tr> 
  <tr> 
   <td><code>SIGNAL</code> ®</td> 
   <td><code>SIGNED</code></td> 
   <td><code>SIMPLE</code></td> 
  </tr> 
  <tr> 
   <td><code>SLAVE</code></td> 
   <td><code>SLOW</code></td> 
   <td><code>SMALLINT</code> ®</td> 
  </tr> 
  <tr> 
   <td><code>SNAPSHOT</code></td> 
   <td><code>SOCKET</code></td> 
   <td><code>SOME</code></td> 
  </tr> 
  <tr> 
   <td><code>SONAME</code></td> 
   <td><code>SOUNDS</code></td> 
   <td><code>SOURCE</code></td> 
  </tr> 
  <tr> 
   <td><code>SPATIAL</code> ®</td> 
   <td><code>SPECIFIC</code> ®</td> 
   <td><code>SQL</code> ®</td> 
  </tr> 
  <tr> 
   <td><code>SQLEXCEPTION</code> ®</td> 
   <td><code>SQLSTATE</code> ®</td> 
   <td><code>SQLWARNING</code> ®</td> 
  </tr> 
  <tr> 
   <td><code>SQL_AFTER_GTIDS</code></td> 
   <td><code>SQL_AFTER_MTS_GAPS</code></td> 
   <td><code>SQL_BEFORE_GTIDS</code></td> 
  </tr> 
  <tr> 
   <td><code>SQL_BIG_RESULT</code> ®</td> 
   <td><code>SQL_BUFFER_RESULT</code></td> 
   <td><code>SQL_CACHE</code></td> 
  </tr> 
  <tr> 
   <td><code>SQL_CALC_FOUND_ROWS</code> ®</td> 
   <td><code>SQL_NO_CACHE</code></td> 
   <td><code>SQL_SMALL_RESULT</code> ®</td> 
  </tr> 
  <tr> 
   <td><code>SQL_THREAD</code></td> 
   <td><code>SQL_TSI_DAY</code></td> 
   <td><code>SQL_TSI_HOUR</code></td> 
  </tr> 
  <tr> 
   <td><code>SQL_TSI_MINUTE</code></td> 
   <td><code>SQL_TSI_MONTH</code></td> 
   <td><code>SQL_TSI_QUARTER</code></td> 
  </tr> 
  <tr> 
   <td><code>SQL_TSI_SECOND</code></td> 
   <td><code>SQL_TSI_WEEK</code></td> 
   <td><code>SQL_TSI_YEAR</code></td> 
  </tr> 
  <tr> 
   <td><code>SSL</code> ®</td> 
   <td><code>STACKED</code></td> 
   <td><code>START</code></td> 
  </tr> 
  <tr> 
   <td><code>STARTING</code> ®</td> 
   <td><code>STARTS</code></td> 
   <td><code>STATS_AUTO_RECALC</code></td> 
  </tr> 
  <tr> 
   <td><code>STATS_PERSISTENT</code></td> 
   <td><code>STATS_SAMPLE_PAGES</code></td> 
   <td><code>STATUS</code></td> 
  </tr> 
  <tr> 
   <td><code>STOP</code></td> 
   <td><code>STORAGE</code></td> 
   <td><code>STORED</code>[<a href="https://dev.mysql.com/doc/refman/5.7/en/keywords.html#ftn.idm140312822806352" rel="nofollow">ac]</a> ®</td> 
  </tr> 
  <tr> 
   <td><code>STRAIGHT_JOIN</code> ®</td> 
   <td><code>STRING</code></td> 
   <td><code>SUBCLASS_ORIGIN</code></td> 
  </tr> 
  <tr> 
   <td><code>SUBJECT</code></td> 
   <td><code>SUBPARTITION</code></td> 
   <td><code>SUBPARTITIONS</code></td> 
  </tr> 
  <tr> 
   <td><code>SUPER</code></td> 
   <td><code>SUSPEND</code></td> 
   <td><code>SWAPS</code></td> 
  </tr> 
  <tr> 
   <td><code>SWITCHES</code></td> 
   <td><code>TABLE</code> ®</td> 
   <td><code>TABLES</code></td> 
  </tr> 
  <tr> 
   <td><code>TABLESPACE</code></td> 
   <td><code>TABLE_CHECKSUM</code></td> 
   <td><code>TABLE_NAME</code></td> 
  </tr> 
  <tr> 
   <td><code>TEMPORARY</code></td> 
   <td><code>TEMPTABLE</code></td> 
   <td><code>TERMINATED</code> ®</td> 
  </tr> 
  <tr> 
   <td><code>TEXT</code></td> 
   <td><code>THAN</code></td> 
   <td><code>THEN</code> ®</td> 
  </tr> 
  <tr> 
   <td><code>TIME</code></td> 
   <td><code>TIMESTAMP</code></td> 
   <td><code>TIMESTAMPADD</code></td> 
  </tr> 
  <tr> 
   <td><code>TIMESTAMPDIFF</code></td> 
   <td><code>TINYBLOB</code> ®</td> 
   <td><code>TINYINT</code> ®</td> 
  </tr> 
  <tr> 
   <td><code>TINYTEXT</code> ®</td> 
   <td><code>TO</code> ®</td> 
   <td><code>TRAILING</code> ®</td> 
  </tr> 
  <tr> 
   <td><code>TRANSACTION</code></td> 
   <td><code>TRIGGER</code> ®</td> 
   <td><code>TRIGGERS</code></td> 
  </tr> 
  <tr> 
   <td><code>TRUE</code> ®</td> 
   <td><code>TRUNCATE</code></td> 
   <td><code>TYPE</code></td> 
  </tr> 
  <tr> 
   <td><code>TYPES</code></td> 
   <td><code>UNCOMMITTED</code></td> 
   <td><code>UNDEFINED</code></td> 
  </tr> 
  <tr> 
   <td><code>UNDO</code> ®</td> 
   <td><code>UNDOFILE</code></td> 
   <td><code>UNDO_BUFFER_SIZE</code></td> 
  </tr> 
  <tr> 
   <td><code>UNICODE</code></td> 
   <td><code>UNINSTALL</code></td> 
   <td><code>UNION</code> ®</td> 
  </tr> 
  <tr> 
   <td><code>UNIQUE</code> ®</td> 
   <td><code>UNKNOWN</code></td> 
   <td><code>UNLOCK</code> ®</td> 
  </tr> 
  <tr> 
   <td><code>UNSIGNED</code> ®</td> 
   <td><code>UNTIL</code></td> 
   <td><code>UPDATE</code> ®</td> 
  </tr> 
  <tr> 
   <td><code>UPGRADE</code></td> 
   <td><code>USAGE</code> ®</td> 
   <td><code>USE</code> ®</td> 
  </tr> 
  <tr> 
   <td><code>USER</code></td> 
   <td><code>USER_RESOURCES</code></td> 
   <td><code>USE_FRM</code></td> 
  </tr> 
  <tr> 
   <td><code>USING</code> ®</td> 
   <td><code>UTC_DATE</code> ®</td> 
   <td><code>UTC_TIME</code> ®</td> 
  </tr> 
  <tr> 
   <td><code>UTC_TIMESTAMP</code> ®</td> 
   <td><code>VALIDATION</code>[<a href="https://dev.mysql.com/doc/refman/5.7/en/keywords.html#ftn.idm140312822715808" rel="nofollow">ad]</a></td> 
   <td><code>VALUE</code></td> 
  </tr> 
  <tr> 
   <td><code>VALUES</code> ®</td> 
   <td><code>VARBINARY</code> ®</td> 
   <td><code>VARCHAR</code> ®</td> 
  </tr> 
  <tr> 
   <td><code>VARCHARACTER</code> ®</td> 
   <td><code>VARIABLES</code></td> 
   <td><code>VARYING</code> ®</td> 
  </tr> 
  <tr> 
   <td><code>VIEW</code></td> 
   <td><code>VIRTUAL</code>[<a href="https://dev.mysql.com/doc/refman/5.7/en/keywords.html#ftn.idm140312822701584" rel="nofollow">ae]</a> ®</td> 
   <td><code>WAIT</code></td> 
  </tr> 
  <tr> 
   <td><code>WARNINGS</code></td> 
   <td><code>WEEK</code></td> 
   <td><code>WEIGHT_STRING</code></td> 
  </tr> 
  <tr> 
   <td><code>WHEN</code> ®</td> 
   <td><code>WHERE</code> ®</td> 
   <td><code>WHILE</code> ®</td> 
  </tr> 
  <tr> 
   <td><code>WITH</code> ®</td> 
   <td><code>WITHOUT</code>[<a href="https://dev.mysql.com/doc/refman/5.7/en/keywords.html#ftn.idm140312822687360" rel="nofollow">af]</a></td> 
   <td><code>WORK</code></td> 
  </tr> 
  <tr> 
   <td><code>WRAPPER</code></td> 
   <td><code>WRITE</code> ®</td> 
   <td><code>X509</code></td> 
  </tr> 
  <tr> 
   <td><code>XA</code></td> 
   <td><code>XID</code>[<a href="https://dev.mysql.com/doc/refman/5.7/en/keywords.html#ftn.idm140312822677936" rel="nofollow">ag]</a></td> 
   <td><code>XML</code></td> 
  </tr> 
  <tr> 
   <td><code>XOR</code> ®</td> 
   <td><code>YEAR</code></td> 
   <td><code>YEAR_MONTH</code> ®</td> 
  </tr> 
  <tr> 
   <td><code>ZEROFILL</code> ®</td> 
   <td></td> 
   <td></td> 
  </tr> 
 </tbody> 
</table>