保留关键字(Reserved Words)导致的Jpa保存错误

àì夳堔傛蜴生んèń 2022-06-08 06:54 160阅读 0赞

使用Jpa操作数据库时，如果字段名称使用了数据库保留关键字，会报错：

Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'option, state, id) values ('2017-09-18 16:50:53.477', '0', '2017-09-18 16:50:53.' at line 1

然后，我到mysql官网查看了一下保留关键字都有(带（R）标识的是保留关键字)，我们在创建表的时候，字段名称表名称注意避免。

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

<table> 
 <tbody> 
 <tr> 
 <td><code>ACCESSIBLE</code> (R)</td> 
 <td><code>ACTION</code></td> 
 <td><code>ADD</code> (R)</td> 
 </tr> 
 <tr> 
 <td><code>AFTER</code></td> 
 <td><code>AGAINST</code></td> 
 <td><code>AGGREGATE</code></td> 
 </tr> 
 <tr> 
 <td><code>ALGORITHM</code></td> 
 <td><code>ALL</code> (R)</td> 
 <td><code>ALTER</code> (R)</td> 
 </tr> 
 <tr> 
 <td><code>ANALYZE</code> (R)</td> 
 <td><code>AND</code> (R)</td> 
 <td><code>ANY</code></td> 
 </tr> 
 <tr> 
 <td><code>AS</code> (R)</td> 
 <td><code>ASC</code> (R)</td> 
 <td><code>ASCII</code></td> 
 </tr> 
 <tr> 
 <td><code>ASENSITIVE</code> (R)</td> 
 <td><code>AT</code></td> 
 <td><code>AUTHORS</code></td> 
 </tr> 
 <tr> 
 <td><code>AUTOEXTEND_SIZE</code></td> 
 <td><code>AUTO_INCREMENT</code></td> 
 <td><code>AVG</code></td> 
 </tr> 
 <tr> 
 <td><code>AVG_ROW_LENGTH</code></td> 
 <td><code>BACKUP</code></td> 
 <td><code>BEFORE</code> (R)</td> 
 </tr> 
 <tr> 
 <td><code>BEGIN</code></td> 
 <td><code>BETWEEN</code> (R)</td> 
 <td><code>BIGINT</code> (R)</td> 
 </tr> 
 <tr> 
 <td><code>BINARY</code> (R)</td> 
 <td><code>BINLOG</code></td> 
 <td><code>BIT</code></td> 
 </tr> 
 <tr> 
 <td><code>BLOB</code> (R)</td> 
 <td><code>BLOCK</code></td> 
 <td><code>BOOL</code></td> 
 </tr> 
 <tr> 
 <td><code>BOOLEAN</code></td> 
 <td><code>BOTH</code> (R)</td> 
 <td><code>BTREE</code></td> 
 </tr> 
 <tr> 
 <td><code>BY</code> (R)</td> 
 <td><code>BYTE</code></td> 
 <td><code>CACHE</code></td> 
 </tr> 
 <tr> 
 <td><code>CALL</code> (R)</td> 
 <td><code>CASCADE</code> (R)</td> 
 <td><code>CASCADED</code></td> 
 </tr> 
 <tr> 
 <td><code>CASE</code> (R)</td> 
 <td><code>CATALOG_NAME</code></td> 
 <td><code>CHAIN</code></td> 
 </tr> 
 <tr> 
 <td><code>CHANGE</code> (R)</td> 
 <td><code>CHANGED</code></td> 
 <td><code>CHAR</code> (R)</td> 
 </tr> 
 <tr> 
 <td><code>CHARACTER</code> (R)</td> 
 <td><code>CHARSET</code></td> 
 <td><code>CHECK</code> (R)</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> (R)</td> 
 <td><code>COLLATION</code></td> 
 </tr> 
 <tr> 
 <td><code>COLUMN</code> (R)</td> 
 <td><code>COLUMNS</code></td> 
 <td><code>COLUMN_NAME</code></td> 
 </tr> 
 <tr> 
 <td><code>COMMENT</code></td> 
 <td><code>COMMIT</code></td> 
 <td><code>COMMITTED</code></td> 
 </tr> 
 <tr> 
 <td><code>COMPACT</code></td> 
 <td><code>COMPLETION</code></td> 
 <td><code>COMPRESSED</code></td> 
 </tr> 
 <tr> 
 <td><code>CONCURRENT</code></td> 
 <td><code>CONDITION</code> (R)</td> 
 <td><code>CONNECTION</code></td> 
 </tr> 
 <tr> 
 <td><code>CONSISTENT</code></td> 
 <td><code>CONSTRAINT</code> (R)</td> 
 <td><code>CONSTRAINT_CATALOG</code></td> 
 </tr> 
 <tr> 
 <td><code>CONSTRAINT_NAME</code></td> 
 <td><code>CONSTRAINT_SCHEMA</code></td> 
 <td><code>CONTAINS</code></td> 
 </tr> 
 <tr> 
 <td><code>CONTEXT</code></td> 
 <td><code>CONTINUE</code> (R)</td> 
 <td><code>CONTRIBUTORS</code></td> 
 </tr> 
 <tr> 
 <td><code>CONVERT</code> (R)</td> 
 <td><code>CPU</code></td> 
 <td><code>CREATE</code> (R)</td> 
 </tr> 
 <tr> 
 <td><code>CROSS</code> (R)</td> 
 <td><code>CUBE</code></td> 
 <td><code>CURRENT_DATE</code> (R)</td> 
 </tr> 
 <tr> 
 <td><code>CURRENT_TIME</code> (R)</td> 
 <td><code>CURRENT_TIMESTAMP</code> (R)</td> 
 <td><code>CURRENT_USER</code> (R)</td> 
 </tr> 
 <tr> 
 <td><code>CURSOR</code> (R)</td> 
 <td><code>CURSOR_NAME</code></td> 
 <td><code>DATA</code></td> 
 </tr> 
 <tr> 
 <td><code>DATABASE</code> (R)</td> 
 <td><code>DATABASES</code> (R)</td> 
 <td><code>DATAFILE</code></td> 
 </tr> 
 <tr> 
 <td><code>DATE</code></td> 
 <td><code>DATETIME</code></td> 
 <td><code>DAY</code></td> 
 </tr> 
 <tr> 
 <td><code>DAY_HOUR</code> (R)</td> 
 <td><code>DAY_MICROSECOND</code> (R)</td> 
 <td><code>DAY_MINUTE</code> (R)</td> 
 </tr> 
 <tr> 
 <td><code>DAY_SECOND</code> (R)</td> 
 <td><code>DEALLOCATE</code></td> 
 <td><code>DEC</code> (R)</td> 
 </tr> 
 <tr> 
 <td><code>DECIMAL</code> (R)</td> 
 <td><code>DECLARE</code> (R)</td> 
 <td><code>DEFAULT</code> (R)</td> 
 </tr> 
 <tr> 
 <td><code>DEFINER</code></td> 
 <td><code>DELAYED</code> (R)</td> 
 <td><code>DELAY_KEY_WRITE</code></td> 
 </tr> 
 <tr> 
 <td><code>DELETE</code> (R)</td> 
 <td><code>DESC</code> (R)</td> 
 <td><code>DESCRIBE</code> (R)</td> 
 </tr> 
 <tr> 
 <td><code>DES_KEY_FILE</code></td> 
 <td><code>DETERMINISTIC</code> (R)</td> 
 <td><code>DIRECTORY</code></td> 
 </tr> 
 <tr> 
 <td><code>DISABLE</code></td> 
 <td><code>DISCARD</code></td> 
 <td><code>DISK</code></td> 
 </tr> 
 <tr> 
 <td><code>DISTINCT</code> (R)</td> 
 <td><code>DISTINCTROW</code> (R)</td> 
 <td><code>DIV</code> (R)</td> 
 </tr> 
 <tr> 
 <td><code>DO</code></td> 
 <td><code>DOUBLE</code> (R)</td> 
 <td><code>DROP</code> (R)</td> 
 </tr> 
 <tr> 
 <td><code>DUAL</code> (R)</td> 
 <td><code>DUMPFILE</code></td> 
 <td><code>DUPLICATE</code></td> 
 </tr> 
 <tr> 
 <td><code>DYNAMIC</code></td> 
 <td><code>EACH</code> (R)</td> 
 <td><code>ELSE</code> (R)</td> 
 </tr> 
 <tr> 
 <td><code>ELSEIF</code> (R)</td> 
 <td><code>ENABLE</code></td> 
 <td><code>ENCLOSED</code> (R)</td> 
 </tr> 
 <tr> 
 <td><code>END</code></td> 
 <td><code>ENDS</code></td> 
 <td><code>ENGINE</code></td> 
 </tr> 
 <tr> 
 <td><code>ENGINES</code></td> 
 <td><code>ENUM</code></td> 
 <td><code>ERROR</code><a rel="nofollow">[a]</a></td> 
 </tr> 
 <tr> 
 <td><code>ERRORS</code></td> 
 <td><code>ESCAPE</code></td> 
 <td><code>ESCAPED</code> (R)</td> 
 </tr> 
 <tr> 
 <td><code>EVENT</code></td> 
 <td><code>EVENTS</code></td> 
 <td><code>EVERY</code></td> 
 </tr> 
 <tr> 
 <td><code>EXECUTE</code></td> 
 <td><code>EXISTS</code> (R)</td> 
 <td><code>EXIT</code> (R)</td> 
 </tr> 
 <tr> 
 <td><code>EXPANSION</code></td> 
 <td><code>EXPLAIN</code> (R)</td> 
 <td><code>EXTENDED</code></td> 
 </tr> 
 <tr> 
 <td><code>EXTENT_SIZE</code></td> 
 <td><code>FALSE</code> (R)</td> 
 <td><code>FAST</code></td> 
 </tr> 
 <tr> 
 <td><code>FAULTS</code></td> 
 <td><code>FETCH</code> (R)</td> 
 <td><code>FIELDS</code></td> 
 </tr> 
 <tr> 
 <td><code>FILE</code></td> 
 <td><code>FIRST</code></td> 
 <td><code>FIXED</code></td> 
 </tr> 
 <tr> 
 <td><code>FLOAT</code> (R)</td> 
 <td><code>FLOAT4</code> (R)</td> 
 <td><code>FLOAT8</code> (R)</td> 
 </tr> 
 <tr> 
 <td><code>FLUSH</code></td> 
 <td><code>FOR</code> (R)</td> 
 <td><code>FORCE</code> (R)</td> 
 </tr> 
 <tr> 
 <td><code>FOREIGN</code> (R)</td> 
 <td><code>FOUND</code></td> 
 <td><code>FRAC_SECOND</code><a rel="nofollow">[b]</a></td> 
 </tr> 
 <tr> 
 <td><code>FROM</code> (R)</td> 
 <td><code>FULL</code></td> 
 <td><code>FULLTEXT</code> (R)</td> 
 </tr> 
 <tr> 
 <td><code>FUNCTION</code></td> 
 <td><code>GENERAL</code><a rel="nofollow">[c]</a></td> 
 <td><code>GEOMETRY</code></td> 
 </tr> 
 <tr> 
 <td><code>GEOMETRYCOLLECTION</code></td> 
 <td><code>GET_FORMAT</code></td> 
 <td><code>GLOBAL</code></td> 
 </tr> 
 <tr> 
 <td><code>GRANT</code> (R)</td> 
 <td><code>GRANTS</code></td> 
 <td><code>GROUP</code> (R)</td> 
 </tr> 
 <tr> 
 <td><code>HANDLER</code></td> 
 <td><code>HASH</code></td> 
 <td><code>HAVING</code> (R)</td> 
 </tr> 
 <tr> 
 <td><code>HELP</code></td> 
 <td><code>HIGH_PRIORITY</code> (R)</td> 
 <td><code>HOST</code></td> 
 </tr> 
 <tr> 
 <td><code>HOSTS</code></td> 
 <td><code>HOUR</code></td> 
 <td><code>HOUR_MICROSECOND</code> (R)</td> 
 </tr> 
 <tr> 
 <td><code>HOUR_MINUTE</code> (R)</td> 
 <td><code>HOUR_SECOND</code> (R)</td> 
 <td><code>IDENTIFIED</code></td> 
 </tr> 
 <tr> 
 <td><code>IF</code> (R)</td> 
 <td><code>IGNORE</code> (R)</td> 
 <td><code>IGNORE_SERVER_IDS</code><a rel="nofollow">[d]</a></td> 
 </tr> 
 <tr> 
 <td><code>IMPORT</code></td> 
 <td><code>IN</code> (R)</td> 
 <td><code>INDEX</code> (R)</td> 
 </tr> 
 <tr> 
 <td><code>INDEXES</code></td> 
 <td><code>INFILE</code> (R)</td> 
 <td><code>INITIAL_SIZE</code></td> 
 </tr> 
 <tr> 
 <td><code>INNER</code> (R)</td> 
 <td><code>INNOBASE</code><a rel="nofollow">[e]</a></td> 
 <td><code>INNODB</code><a rel="nofollow">[f]</a></td> 
 </tr> 
 <tr> 
 <td><code>INOUT</code> (R)</td> 
 <td><code>INSENSITIVE</code> (R)</td> 
 <td><code>INSERT</code> (R)</td> 
 </tr> 
 <tr> 
 <td><code>INSERT_METHOD</code></td> 
 <td><code>INSTALL</code></td> 
 <td><code>INT</code> (R)</td> 
 </tr> 
 <tr> 
 <td><code>INT1</code> (R)</td> 
 <td><code>INT2</code> (R)</td> 
 <td><code>INT3</code> (R)</td> 
 </tr> 
 <tr> 
 <td><code>INT4</code> (R)</td> 
 <td><code>INT8</code> (R)</td> 
 <td><code>INTEGER</code> (R)</td> 
 </tr> 
 <tr> 
 <td><code>INTERVAL</code> (R)</td> 
 <td><code>INTO</code> (R)</td> 
 <td><code>INVOKER</code></td> 
 </tr> 
 <tr> 
 <td><code>IO</code></td> 
 <td><code>IO_THREAD</code></td> 
 <td><code>IPC</code></td> 
 </tr> 
 <tr> 
 <td><code>IS</code> (R)</td> 
 <td><code>ISOLATION</code></td> 
 <td><code>ISSUER</code></td> 
 </tr> 
 <tr> 
 <td><code>ITERATE</code> (R)</td> 
 <td><code>JOIN</code> (R)</td> 
 <td><code>KEY</code> (R)</td> 
 </tr> 
 <tr> 
 <td><code>KEYS</code> (R)</td> 
 <td><code>KEY_BLOCK_SIZE</code></td> 
 <td><code>KILL</code> (R)</td> 
 </tr> 
 <tr> 
 <td><code>LANGUAGE</code></td> 
 <td><code>LAST</code></td> 
 <td><code>LEADING</code> (R)</td> 
 </tr> 
 <tr> 
 <td><code>LEAVE</code> (R)</td> 
 <td><code>LEAVES</code></td> 
 <td><code>LEFT</code> (R)</td> 
 </tr> 
 <tr> 
 <td><code>LESS</code></td> 
 <td><code>LEVEL</code></td> 
 <td><code>LIKE</code> (R)</td> 
 </tr> 
 <tr> 
 <td><code>LIMIT</code> (R)</td> 
 <td><code>LINEAR</code> (R)</td> 
 <td><code>LINES</code> (R)</td> 
 </tr> 
 <tr> 
 <td><code>LINESTRING</code></td> 
 <td><code>LIST</code></td> 
 <td><code>LOAD</code> (R)</td> 
 </tr> 
 <tr> 
 <td><code>LOCAL</code></td> 
 <td><code>LOCALTIME</code> (R)</td> 
 <td><code>LOCALTIMESTAMP</code> (R)</td> 
 </tr> 
 <tr> 
 <td><code>LOCK</code> (R)</td> 
 <td><code>LOCKS</code></td> 
 <td><code>LOGFILE</code></td> 
 </tr> 
 <tr> 
 <td><code>LOGS</code></td> 
 <td><code>LONG</code> (R)</td> 
 <td><code>LONGBLOB</code> (R)</td> 
 </tr> 
 <tr> 
 <td><code>LONGTEXT</code> (R)</td> 
 <td><code>LOOP</code> (R)</td> 
 <td><code>LOW_PRIORITY</code> (R)</td> 
 </tr> 
 <tr> 
 <td><code>MASTER</code></td> 
 <td><code>MASTER_CONNECT_RETRY</code></td> 
 <td><code>MASTER_HEARTBEAT_PERIOD</code><a rel="nofollow">[g]</a></td> 
 </tr> 
 <tr> 
 <td><code>MASTER_HOST</code></td> 
 <td><code>MASTER_LOG_FILE</code></td> 
 <td><code>MASTER_LOG_POS</code></td> 
 </tr> 
 <tr> 
 <td><code>MASTER_PASSWORD</code></td> 
 <td><code>MASTER_PORT</code></td> 
 <td><code>MASTER_SERVER_ID</code></td> 
 </tr> 
 <tr> 
 <td><code>MASTER_SSL</code></td> 
 <td><code>MASTER_SSL_CA</code></td> 
 <td><code>MASTER_SSL_CAPATH</code></td> 
 </tr> 
 <tr> 
 <td><code>MASTER_SSL_CERT</code></td> 
 <td><code>MASTER_SSL_CIPHER</code></td> 
 <td><code>MASTER_SSL_KEY</code></td> 
 </tr> 
 <tr> 
 <td><code>MASTER_SSL_VERIFY_SERVER_CERT</code> (R)</td> 
 <td><code>MASTER_USER</code></td> 
 <td><code>MATCH</code> (R)</td> 
 </tr> 
 <tr> 
 <td><code>MAXVALUE</code> (R)</td> 
 <td><code>MAX_CONNECTIONS_PER_HOUR</code></td> 
 <td><code>MAX_QUERIES_PER_HOUR</code></td> 
 </tr> 
 <tr> 
 <td><code>MAX_ROWS</code></td> 
 <td><code>MAX_SIZE</code></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> (R)</td> 
 </tr> 
 <tr> 
 <td><code>MEDIUMINT</code> (R)</td> 
 <td><code>MEDIUMTEXT</code> (R)</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> (R)</td> 
 <td><code>MIGRATE</code></td> 
 <td><code>MINUTE</code></td> 
 </tr> 
 <tr> 
 <td><code>MINUTE_MICROSECOND</code> (R)</td> 
 <td><code>MINUTE_SECOND</code> (R)</td> 
 <td><code>MIN_ROWS</code></td> 
 </tr> 
 <tr> 
 <td><code>MOD</code> (R)</td> 
 <td><code>MODE</code></td> 
 <td><code>MODIFIES</code> (R)</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> (R)</td> 
 <td><code>NCHAR</code></td> 
 </tr> 
 <tr> 
 <td><code>NDB</code></td> 
 <td><code>NDBCLUSTER</code></td> 
 <td><code>NEW</code></td> 
 </tr> 
 <tr> 
 <td><code>NEXT</code></td> 
 <td><code>NO</code></td> 
 <td><code>NODEGROUP</code></td> 
 </tr> 
 <tr> 
 <td><code>NONE</code></td> 
 <td><code>NOT</code> (R)</td> 
 <td><code>NO_WAIT</code></td> 
 </tr> 
 <tr> 
 <td><code>NO_WRITE_TO_BINLOG</code> (R)</td> 
 <td><code>NULL</code> (R)</td> 
 <td><code>NUMERIC</code> (R)</td> 
 </tr> 
 <tr> 
 <td><code>NVARCHAR</code></td> 
 <td><code>OFFSET</code></td> 
 <td><code>OLD_PASSWORD</code></td> 
 </tr> 
 <tr> 
 <td><code>ON</code> (R)</td> 
 <td><code>ONE</code></td> 
 <td><code>ONE_SHOT</code></td> 
 </tr> 
 <tr> 
 <td><code>OPEN</code></td> 
 <td><code>OPTIMIZE</code> (R)</td> 
 <td><code>OPTION</code> (R)</td> 
 </tr> 
 <tr> 
 <td><code>OPTIONALLY</code> (R)</td> 
 <td><code>OPTIONS</code></td> 
 <td><code>OR</code> (R)</td> 
 </tr> 
 <tr> 
 <td><code>ORDER</code> (R)</td> 
 <td><code>OUT</code> (R)</td> 
 <td><code>OUTER</code> (R)</td> 
 </tr> 
 <tr> 
 <td><code>OUTFILE</code> (R)</td> 
 <td><code>OWNER</code></td> 
 <td><code>PACK_KEYS</code></td> 
 </tr> 
 <tr> 
 <td><code>PAGE</code></td> 
 <td><code>PARSER</code></td> 
 <td><code>PARTIAL</code></td> 
 </tr> 
 <tr> 
 <td><code>PARTITION</code></td> 
 <td><code>PARTITIONING</code></td> 
 <td><code>PARTITIONS</code></td> 
 </tr> 
 <tr> 
 <td><code>PASSWORD</code></td> 
 <td><code>PHASE</code></td> 
 <td><code>PLUGIN</code></td> 
 </tr> 
 <tr> 
 <td><code>PLUGINS</code></td> 
 <td><code>POINT</code></td> 
 <td><code>POLYGON</code></td> 
 </tr> 
 <tr> 
 <td><code>PORT</code></td> 
 <td><code>PRECISION</code> (R)</td> 
 <td><code>PREPARE</code></td> 
 </tr> 
 <tr> 
 <td><code>PRESERVE</code></td> 
 <td><code>PREV</code></td> 
 <td><code>PRIMARY</code> (R)</td> 
 </tr> 
 <tr> 
 <td><code>PRIVILEGES</code></td> 
 <td><code>PROCEDURE</code> (R)</td> 
 <td><code>PROCESSLIST</code></td> 
 </tr> 
 <tr> 
 <td><code>PROFILE</code></td> 
 <td><code>PROFILES</code></td> 
 <td><code>PROXY</code><a rel="nofollow">[h]</a></td> 
 </tr> 
 <tr> 
 <td><code>PURGE</code> (R)</td> 
 <td><code>QUARTER</code></td> 
 <td><code>QUERY</code></td> 
 </tr> 
 <tr> 
 <td><code>QUICK</code></td> 
 <td><code>RANGE</code> (R)</td> 
 <td><code>READ</code> (R)</td> 
 </tr> 
 <tr> 
 <td><code>READS</code> (R)</td> 
 <td><code>READ_ONLY</code></td> 
 <td><code>READ_WRITE</code> (R)</td> 
 </tr> 
 <tr> 
 <td><code>REAL</code> (R)</td> 
 <td><code>REBUILD</code></td> 
 <td><code>RECOVER</code></td> 
 </tr> 
 <tr> 
 <td><code>REDOFILE</code></td> 
 <td><code>REDO_BUFFER_SIZE</code></td> 
 <td><code>REDUNDANT</code></td> 
 </tr> 
 <tr> 
 <td><code>REFERENCES</code> (R)</td> 
 <td><code>REGEXP</code> (R)</td> 
 <td><code>RELAY</code><a rel="nofollow">[i]</a></td> 
 </tr> 
 <tr> 
 <td><code>RELAYLOG</code></td> 
 <td><code>RELAY_LOG_FILE</code></td> 
 <td><code>RELAY_LOG_POS</code></td> 
 </tr> 
 <tr> 
 <td><code>RELAY_THREAD</code></td> 
 <td><code>RELEASE</code> (R)</td> 
 <td><code>RELOAD</code></td> 
 </tr> 
 <tr> 
 <td><code>REMOVE</code></td> 
 <td><code>RENAME</code> (R)</td> 
 <td><code>REORGANIZE</code></td> 
 </tr> 
 <tr> 
 <td><code>REPAIR</code></td> 
 <td><code>REPEAT</code> (R)</td> 
 <td><code>REPEATABLE</code></td> 
 </tr> 
 <tr> 
 <td><code>REPLACE</code> (R)</td> 
 <td><code>REPLICATION</code></td> 
 <td><code>REQUIRE</code> (R)</td> 
 </tr> 
 <tr> 
 <td><code>RESET</code></td> 
 <td><code>RESIGNAL</code> (R)</td> 
 <td><code>RESTORE</code></td> 
 </tr> 
 <tr> 
 <td><code>RESTRICT</code> (R)</td> 
 <td><code>RESUME</code></td> 
 <td><code>RETURN</code> (R)</td> 
 </tr> 
 <tr> 
 <td><code>RETURNS</code></td> 
 <td><code>REVOKE</code> (R)</td> 
 <td><code>RIGHT</code> (R)</td> 
 </tr> 
 <tr> 
 <td><code>RLIKE</code> (R)</td> 
 <td><code>ROLLBACK</code></td> 
 <td><code>ROLLUP</code></td> 
 </tr> 
 <tr> 
 <td><code>ROUTINE</code></td> 
 <td><code>ROW</code></td> 
 <td><code>ROWS</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> (R)</td> 
 <td><code>SCHEMAS</code> (R)</td> 
 </tr> 
 <tr> 
 <td><code>SCHEMA_NAME</code></td> 
 <td><code>SECOND</code></td> 
 <td><code>SECOND_MICROSECOND</code> (R)</td> 
 </tr> 
 <tr> 
 <td><code>SECURITY</code></td> 
 <td><code>SELECT</code> (R)</td> 
 <td><code>SENSITIVE</code> (R)</td> 
 </tr> 
 <tr> 
 <td><code>SEPARATOR</code> (R)</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> (R)</td> 
 </tr> 
 <tr> 
 <td><code>SHARE</code></td> 
 <td><code>SHOW</code> (R)</td> 
 <td><code>SHUTDOWN</code></td> 
 </tr> 
 <tr> 
 <td><code>SIGNAL</code> (R)</td> 
 <td><code>SIGNED</code></td> 
 <td><code>SIMPLE</code></td> 
 </tr> 
 <tr> 
 <td><code>SLAVE</code></td> 
 <td><code>SLOW</code><a rel="nofollow">[j]</a></td> 
 <td><code>SMALLINT</code> (R)</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> (R)</td> 
 <td><code>SPECIFIC</code> (R)</td> 
 <td><code>SQL</code> (R)</td> 
 </tr> 
 <tr> 
 <td><code>SQLEXCEPTION</code> (R)</td> 
 <td><code>SQLSTATE</code> (R)</td> 
 <td><code>SQLWARNING</code> (R)</td> 
 </tr> 
 <tr> 
 <td><code>SQL_BIG_RESULT</code> (R)</td> 
 <td><code>SQL_BUFFER_RESULT</code></td> 
 <td><code>SQL_CACHE</code></td> 
 </tr> 
 <tr> 
 <td><code>SQL_CALC_FOUND_ROWS</code> (R)</td> 
 <td><code>SQL_NO_CACHE</code></td> 
 <td><code>SQL_SMALL_RESULT</code> (R)</td> 
 </tr> 
 <tr> 
 <td><code>SQL_THREAD</code></td> 
 <td><code>SQL_TSI_DAY</code></td> 
 <td><code>SQL_TSI_FRAC_SECOND</code><a rel="nofollow">[k]</a></td> 
 </tr> 
 <tr> 
 <td><code>SQL_TSI_HOUR</code></td> 
 <td><code>SQL_TSI_MINUTE</code></td> 
 <td><code>SQL_TSI_MONTH</code></td> 
 </tr> 
 <tr> 
 <td><code>SQL_TSI_QUARTER</code></td> 
 <td><code>SQL_TSI_SECOND</code></td> 
 <td><code>SQL_TSI_WEEK</code></td> 
 </tr> 
 <tr> 
 <td><code>SQL_TSI_YEAR</code></td> 
 <td><code>SSL</code> (R)</td> 
 <td><code>START</code></td> 
 </tr> 
 <tr> 
 <td><code>STARTING</code> (R)</td> 
 <td><code>STARTS</code></td> 
 <td><code>STATUS</code></td> 
 </tr> 
 <tr> 
 <td><code>STOP</code></td> 
 <td><code>STORAGE</code></td> 
 <td><code>STRAIGHT_JOIN</code> (R)</td> 
 </tr> 
 <tr> 
 <td><code>STRING</code></td> 
 <td><code>SUBCLASS_ORIGIN</code></td> 
 <td><code>SUBJECT</code></td> 
 </tr> 
 <tr> 
 <td><code>SUBPARTITION</code></td> 
 <td><code>SUBPARTITIONS</code></td> 
 <td><code>SUPER</code></td> 
 </tr> 
 <tr> 
 <td><code>SUSPEND</code></td> 
 <td><code>SWAPS</code></td> 
 <td><code>SWITCHES</code></td> 
 </tr> 
 <tr> 
 <td><code>TABLE</code> (R)</td> 
 <td><code>TABLES</code></td> 
 <td><code>TABLESPACE</code></td> 
 </tr> 
 <tr> 
 <td><code>TABLE_CHECKSUM</code></td> 
 <td><code>TABLE_NAME</code></td> 
 <td><code>TEMPORARY</code></td> 
 </tr> 
 <tr> 
 <td><code>TEMPTABLE</code></td> 
 <td><code>TERMINATED</code> (R)</td> 
 <td><code>TEXT</code></td> 
 </tr> 
 <tr> 
 <td><code>THAN</code></td> 
 <td><code>THEN</code> (R)</td> 
 <td><code>TIME</code></td> 
 </tr> 
 <tr> 
 <td><code>TIMESTAMP</code></td> 
 <td><code>TIMESTAMPADD</code></td> 
 <td><code>TIMESTAMPDIFF</code></td> 
 </tr> 
 <tr> 
 <td><code>TINYBLOB</code> (R)</td> 
 <td><code>TINYINT</code> (R)</td> 
 <td><code>TINYTEXT</code> (R)</td> 
 </tr> 
 <tr> 
 <td><code>TO</code> (R)</td> 
 <td><code>TRAILING</code> (R)</td> 
 <td><code>TRANSACTION</code></td> 
 </tr> 
 <tr> 
 <td><code>TRIGGER</code> (R)</td> 
 <td><code>TRIGGERS</code></td> 
 <td><code>TRUE</code> (R)</td> 
 </tr> 
 <tr> 
 <td><code>TRUNCATE</code></td> 
 <td><code>TYPE</code></td> 
 <td><code>TYPES</code></td> 
 </tr> 
 <tr> 
 <td><code>UNCOMMITTED</code></td> 
 <td><code>UNDEFINED</code></td> 
 <td><code>UNDO</code> (R)</td> 
 </tr> 
 <tr> 
 <td><code>UNDOFILE</code></td> 
 <td><code>UNDO_BUFFER_SIZE</code></td> 
 <td><code>UNICODE</code></td> 
 </tr> 
 <tr> 
 <td><code>UNINSTALL</code></td> 
 <td><code>UNION</code> (R)</td> 
 <td><code>UNIQUE</code> (R)</td> 
 </tr> 
 <tr> 
 <td><code>UNKNOWN</code></td> 
 <td><code>UNLOCK</code> (R)</td> 
 <td><code>UNSIGNED</code> (R)</td> 
 </tr> 
 <tr> 
 <td><code>UNTIL</code></td> 
 <td><code>UPDATE</code> (R)</td> 
 <td><code>UPGRADE</code></td> 
 </tr> 
 <tr> 
 <td><code>USAGE</code> (R)</td> 
 <td><code>USE</code> (R)</td> 
 <td><code>USER</code></td> 
 </tr> 
 <tr> 
 <td><code>USER_RESOURCES</code></td> 
 <td><code>USE_FRM</code></td> 
 <td><code>USING</code> (R)</td> 
 </tr> 
 <tr> 
 <td><code>UTC_DATE</code> (R)</td> 
 <td><code>UTC_TIME</code> (R)</td> 
 <td><code>UTC_TIMESTAMP</code> (R)</td> 
 </tr> 
 <tr> 
 <td><code>VALUE</code></td> 
 <td><code>VALUES</code> (R)</td> 
 <td><code>VARBINARY</code> (R)</td> 
 </tr> 
 <tr> 
 <td><code>VARCHAR</code> (R)</td> 
 <td><code>VARCHARACTER</code> (R)</td> 
 <td><code>VARIABLES</code></td> 
 </tr> 
 <tr> 
 <td><code>VARYING</code> (R)</td> 
 <td><code>VIEW</code></td> 
 <td><code>WAIT</code></td> 
 </tr> 
 <tr> 
 <td><code>WARNINGS</code></td> 
 <td><code>WEEK</code></td> 
 <td><code>WHEN</code> (R)</td> 
 </tr> 
 <tr> 
 <td><code>WHERE</code> (R)</td> 
 <td><code>WHILE</code> (R)</td> 
 <td><code>WITH</code> (R)</td> 
 </tr> 
 <tr> 
 <td><code>WORK</code></td> 
 <td><code>WRAPPER</code></td> 
 <td><code>WRITE</code> (R)</td> 
 </tr> 
 <tr> 
 <td><code>X509</code></td> 
 <td><code>XA</code></td> 
 <td><code>XML</code></td> 
 </tr> 
 <tr> 
 <td><code>XOR</code> (R)</td> 
 <td><code>YEAR</code></td> 
 <td><code>YEAR_MONTH</code> (R)</td> 
 </tr> 
 <tr> 
 <td><code>ZEROFILL</code> (R)</td> 
 <td>&nbsp;</td> 
 <td>&nbsp;</td> 
 </tr> 
 </tbody> 
</table>

\[a\] `ERROR`: added in 5.5.3 (nonreserved)

\[b\] `FRAC_SECOND`: removed in 5.5.3

\[c\] `GENERAL`: added in 5.5.3 (reserved); became nonreserved in 5.5.8

\[d\] `IGNORE_SERVER_IDS`: became nonreserved in 5.5.8

\[e\] `INNOBASE`: removed in 5.5.3

\[f\] `INNODB`: removed in 5.5.3

\[g\] `MASTER_HEARTBEAT_PERIOD`: became nonreserved in 5.5.8

\[h\] `PROXY`: added in 5.5.7 (nonreserved)

\[i\] `RELAY`: added in 5.5.3 (nonreserved)

\[j\] `SLOW`: added in 5.5.3 (reserved); became nonreserved in 5.5.8

\[k\] `SQL_TSI_FRAC_SECOND`: removed in 5.5.3