mysql中的关键字

逃离我推掉我的手 2022-09-25 06:21 141阅读 0赞

在MySQL中，下表中的字词显式被保留。其中大多数字进制被标准SQL用作列名和/或表名(例如，GROUP)。少数被保留了，因为MySQL需要它们，保留字被引起来后可以用作识别符。

<table style="margin:0px; padding:0px; border-spacing:0px; border-collapse:collapse; border:1px solid silver; word-break:break-word; color:rgb(73,73,73); font-size:14px; line-height:22.4px; width:620px; background-color:rgb(244,237,227)"> 
 <tbody style="margin:0px; padding:0px"> 
  <tr style="margin:0px; padding:0px"> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> ADD</td> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> ALL</td> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> ALTER</td> 
  </tr> 
  <tr style="margin:0px; padding:0px"> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> ANALYZE</td> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> AND</td> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> AS</td> 
  </tr> 
  <tr style="margin:0px; padding:0px"> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> ASC</td> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> ASENSITIVE</td> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> BEFORE</td> 
  </tr> 
  <tr style="margin:0px; padding:0px"> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> BETWEEN</td> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> BIGINT</td> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> BINARY</td> 
  </tr> 
  <tr style="margin:0px; padding:0px"> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> BLOB</td> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> BOTH</td> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> BY</td> 
  </tr> 
  <tr style="margin:0px; padding:0px"> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> CALL</td> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> CASCADE</td> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> CASE</td> 
  </tr> 
  <tr style="margin:0px; padding:0px"> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> CHANGE</td> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> CHAR</td> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> CHARACTER</td> 
  </tr> 
  <tr style="margin:0px; padding:0px"> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> CHECK</td> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> COLLATE</td> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> COLUMN</td> 
  </tr> 
  <tr style="margin:0px; padding:0px"> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> CONDITION</td> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> CONNECTION</td> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> CONSTRAINT</td> 
  </tr> 
  <tr style="margin:0px; padding:0px"> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> CONTINUE</td> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> CONVERT</td> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> CREATE</td> 
  </tr> 
  <tr style="margin:0px; padding:0px"> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> CROSS</td> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> CURRENT_DATE</td> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> CURRENT_TIME</td> 
  </tr> 
  <tr style="margin:0px; padding:0px"> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> CURRENT_TIMESTAMP</td> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> CURRENT_USER</td> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> CURSOR</td> 
  </tr> 
  <tr style="margin:0px; padding:0px"> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> DATABASE</td> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> DATABASES</td> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> DAY_HOUR</td> 
  </tr> 
  <tr style="margin:0px; padding:0px"> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> DAY_MICROSECOND</td> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> DAY_MINUTE</td> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> DAY_SECOND</td> 
  </tr> 
  <tr style="margin:0px; padding:0px"> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> DEC</td> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> DECIMAL</td> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> DECLARE</td> 
  </tr> 
  <tr style="margin:0px; padding:0px"> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> DEFAULT</td> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> DELAYED</td> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> DELETE</td> 
  </tr> 
  <tr style="margin:0px; padding:0px"> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> DESC</td> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> DESCRIBE</td> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> DETERMINISTIC</td> 
  </tr> 
  <tr style="margin:0px; padding:0px"> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> DISTINCT</td> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> DISTINCTROW</td> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> DIV</td> 
  </tr> 
  <tr style="margin:0px; padding:0px"> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> DOUBLE</td> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> DROP</td> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> DUAL</td> 
  </tr> 
  <tr style="margin:0px; padding:0px"> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> EACH</td> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> ELSE</td> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> ELSEIF</td> 
  </tr> 
  <tr style="margin:0px; padding:0px"> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> ENCLOSED</td> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> ESCAPED</td> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> EXISTS</td> 
  </tr> 
  <tr style="margin:0px; padding:0px"> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> EXIT</td> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> EXPLAIN</td> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> FALSE</td> 
  </tr> 
  <tr style="margin:0px; padding:0px"> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> FETCH</td> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> FLOAT</td> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> FLOAT4</td> 
  </tr> 
  <tr style="margin:0px; padding:0px"> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> FLOAT8</td> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> FOR</td> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> FORCE</td> 
  </tr> 
  <tr style="margin:0px; padding:0px"> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> FOREIGN</td> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> FROM</td> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> FULLTEXT</td> 
  </tr> 
  <tr style="margin:0px; padding:0px"> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> GOTO</td> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> GRANT</td> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> GROUP</td> 
  </tr> 
  <tr style="margin:0px; padding:0px"> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> HAVING</td> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> HIGH_PRIORITY</td> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> HOUR_MICROSECOND</td> 
  </tr> 
  <tr style="margin:0px; padding:0px"> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> HOUR_MINUTE</td> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> HOUR_SECOND</td> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> IF</td> 
  </tr> 
  <tr style="margin:0px; padding:0px"> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> IGNORE</td> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> IN</td> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> INDEX</td> 
  </tr> 
  <tr style="margin:0px; padding:0px"> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> INFILE</td> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> INNER</td> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> INOUT</td> 
  </tr> 
  <tr style="margin:0px; padding:0px"> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> INSENSITIVE</td> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> INSERT</td> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> INT</td> 
  </tr> 
  <tr style="margin:0px; padding:0px"> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> INT1</td> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> INT2</td> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> INT3</td> 
  </tr> 
  <tr style="margin:0px; padding:0px"> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> INT4</td> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> INT8</td> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> INTEGER</td> 
  </tr> 
  <tr style="margin:0px; padding:0px"> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> INTERVAL</td> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> INTO</td> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> IS</td> 
  </tr> 
  <tr style="margin:0px; padding:0px"> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> ITERATE</td> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> JOIN</td> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> KEY</td> 
  </tr> 
  <tr style="margin:0px; padding:0px"> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> KEYS</td> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> KILL</td> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> LABEL</td> 
  </tr> 
  <tr style="margin:0px; padding:0px"> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> LEADING</td> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> LEAVE</td> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> LEFT</td> 
  </tr> 
  <tr style="margin:0px; padding:0px"> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> LIKE</td> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> LIMIT</td> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> LINEAR</td> 
  </tr> 
  <tr style="margin:0px; padding:0px"> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> LINES</td> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> LOAD</td> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> LOCALTIME</td> 
  </tr> 
  <tr style="margin:0px; padding:0px"> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> LOCALTIMESTAMP</td> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> LOCK</td> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> LONG</td> 
  </tr> 
  <tr style="margin:0px; padding:0px"> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> LONGBLOB</td> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> LONGTEXT</td> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> LOOP</td> 
  </tr> 
  <tr style="margin:0px; padding:0px"> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> LOW_PRIORITY</td> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> MATCH</td> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> MEDIUMBLOB</td> 
  </tr> 
  <tr style="margin:0px; padding:0px"> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> MEDIUMINT</td> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> MEDIUMTEXT</td> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> MIDDLEINT</td> 
  </tr> 
  <tr style="margin:0px; padding:0px"> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> MINUTE_MICROSECOND</td> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> MINUTE_SECOND</td> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> MOD</td> 
  </tr> 
  <tr style="margin:0px; padding:0px"> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> MODIFIES</td> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> NATURAL</td> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> NOT</td> 
  </tr> 
  <tr style="margin:0px; padding:0px"> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> NO_WRITE_TO_BINLOG</td> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> NULL</td> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> NUMERIC</td> 
  </tr> 
  <tr style="margin:0px; padding:0px"> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> ON</td> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> OPTIMIZE</td> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> OPTION</td> 
  </tr> 
  <tr style="margin:0px; padding:0px"> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> OPTIONALLY</td> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> OR</td> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> ORDER</td> 
  </tr> 
  <tr style="margin:0px; padding:0px"> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> OUT</td> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> OUTER</td> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> OUTFILE</td> 
  </tr> 
  <tr style="margin:0px; padding:0px"> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> PRECISION</td> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> PRIMARY</td> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> PROCEDURE</td> 
  </tr> 
  <tr style="margin:0px; padding:0px"> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> PURGE</td> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> RAID0</td> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> RANGE</td> 
  </tr> 
  <tr style="margin:0px; padding:0px"> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> READ</td> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> READS</td> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> REAL</td> 
  </tr> 
  <tr style="margin:0px; padding:0px"> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> REFERENCES</td> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> REGEXP</td> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> RELEASE</td> 
  </tr> 
  <tr style="margin:0px; padding:0px"> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> RENAME</td> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> REPEAT</td> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> REPLACE</td> 
  </tr> 
  <tr style="margin:0px; padding:0px"> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> REQUIRE</td> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> RESTRICT</td> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> RETURN</td> 
  </tr> 
  <tr style="margin:0px; padding:0px"> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> REVOKE</td> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> RIGHT</td> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> RLIKE</td> 
  </tr> 
  <tr style="margin:0px; padding:0px"> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> SCHEMA</td> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> SCHEMAS</td> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> SECOND_MICROSECOND</td> 
  </tr> 
  <tr style="margin:0px; padding:0px"> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> SELECT</td> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> SENSITIVE</td> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> SEPARATOR</td> 
  </tr> 
  <tr style="margin:0px; padding:0px"> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> SET</td> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> SHOW</td> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> SMALLINT</td> 
  </tr> 
  <tr style="margin:0px; padding:0px"> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> SPATIAL</td> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> SPECIFIC</td> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> SQL</td> 
  </tr> 
  <tr style="margin:0px; padding:0px"> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> SQLEXCEPTION</td> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> SQLSTATE</td> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> SQLWARNING</td> 
  </tr> 
  <tr style="margin:0px; padding:0px"> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> SQL_BIG_RESULT</td> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> SQL_CALC_FOUND_ROWS</td> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> SQL_SMALL_RESULT</td> 
  </tr> 
  <tr style="margin:0px; padding:0px"> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> SSL</td> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> STARTING</td> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> STRAIGHT_JOIN</td> 
  </tr> 
  <tr style="margin:0px; padding:0px"> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> TABLE</td> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> TERMINATED</td> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> THEN</td> 
  </tr> 
  <tr style="margin:0px; padding:0px"> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> TINYBLOB</td> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> TINYINT</td> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> TINYTEXT</td> 
  </tr> 
  <tr style="margin:0px; padding:0px"> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> TO</td> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> TRAILING</td> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> TRIGGER</td> 
  </tr> 
  <tr style="margin:0px; padding:0px"> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> TRUE</td> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> UNDO</td> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> UNION</td> 
  </tr> 
  <tr style="margin:0px; padding:0px"> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> UNIQUE</td> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> UNLOCK</td> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> UNSIGNED</td> 
  </tr> 
  <tr style="margin:0px; padding:0px"> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> UPDATE</td> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> USAGE</td> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> USE</td> 
  </tr> 
  <tr style="margin:0px; padding:0px"> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> USING</td> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> UTC_DATE</td> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> UTC_TIME</td> 
  </tr> 
  <tr style="margin:0px; padding:0px"> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> UTC_TIMESTAMP</td> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> VALUES</td> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> VARBINARY</td> 
  </tr> 
  <tr style="margin:0px; padding:0px"> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> VARCHAR</td> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> VARCHARACTER</td> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> VARYING</td> 
  </tr> 
  <tr style="margin:0px; padding:0px"> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> WHEN</td> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> WHERE</td> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> WHILE</td> 
  </tr> 
  <tr style="margin:0px; padding:0px"> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> WITH</td> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> WRITE</td> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> X509</td> 
  </tr> 
  <tr style="margin:0px; padding:0px"> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> XOR</td> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> YEAR_MONTH</td> 
   <td style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> ZEROFILL</td> 
  </tr> 
 </tbody> 
</table>

除MySQL允许部分关键字用做未引起来的识别符，因为许多人以前曾使用过它们。下面列出了一些例子：   
ACTION   
BIT   
DATE   
ENUM   
NO   
TEXT   
TIME   
TIMESTAMP