mysql reserves all sorts of things

diff --git a/etc/sql-reserved-words.txt b/etc/sql-reserved-words.txt
index dc507ce..89dea74 100644 (file)
--- a/etc/sql-reserved-words.txt
+++ b/etc/sql-reserved-words.txt
@@ -101,3 +101,116 @@ SQL3 words are not set in stone, but you'd do well to avoid them.
 
          CALL, DO, ELSEIF, EXCEPTION, IF, LEAVE, LOOP, OTHERS, RESIGNAL,
          RETURN, RETURNS, SIGNAL, TUPLE, WHILE
 
          CALL, DO, ELSEIF, EXCEPTION, IF, LEAVE, LOOP, OTHERS, RESIGNAL,
          RETURN, RETURNS, SIGNAL, TUPLE, WHILE

+
+from http://dev.mysql.com/doc/refman/5.6/en/reserved-words.html
+
+ACCESSIBLE     ADD     ALL
+ALTER  ANALYZE         AND
+AS     ASC     ASENSITIVE
+BEFORE         BETWEEN         BIGINT
+BINARY         BLOB    BOTH
+BY     CALL    CASCADE
+CASE   CHANGE  CHAR
+CHARACTER      CHECK   COLLATE
+COLUMN         CONDITION       CONSTRAINT
+CONTINUE       CONVERT         CREATE
+CROSS  CURRENT_DATE    CURRENT_TIME
+CURRENT_TIMESTAMP      CURRENT_USER    CURSOR
+DATABASE       DATABASES       DAY_HOUR
+DAY_MICROSECOND        DAY_MINUTE      DAY_SECOND
+DEC    DECIMAL         DECLARE
+DEFAULT        DELAYED         DELETE
+DESC   DESCRIBE        DETERMINISTIC
+DISTINCT       DISTINCTROW     DIV
+DOUBLE         DROP    DUAL
+EACH   ELSE    ELSEIF
+ENCLOSED       ESCAPED         EXISTS
+EXIT   EXPLAIN         FALSE
+FETCH  FLOAT   FLOAT4
+FLOAT8         FOR     FORCE
+FOREIGN        FROM    FULLTEXT
+GENERAL        GRANT   GROUP
+HAVING         HIGH_PRIORITY   HOUR_MICROSECOND
+HOUR_MINUTE    HOUR_SECOND     IF
+IGNORE         IGNORE_SERVER_IDS       IN
+INDEX  INFILE  INNER
+INOUT  INSENSITIVE     INSERT
+INT    INT1    INT2
+INT3   INT4    INT8
+INTEGER        INTERVAL        INTO
+IS     ITERATE         JOIN
+KEY    KEYS    KILL
+LEADING        LEAVE   LEFT
+LIKE   LIMIT   LINEAR
+LINES  LOAD    LOCALTIME
+LOCALTIMESTAMP         LOCK    LONG
+LONGBLOB       LONGTEXT        LOOP
+LOW_PRIORITY   MASTER_HEARTBEAT_PERIOD         MASTER_SSL_VERIFY_SERVER_CERT
+MATCH  MAXVALUE        MEDIUMBLOB
+MEDIUMINT      MEDIUMTEXT      MIDDLEINT
+MINUTE_MICROSECOND     MINUTE_SECOND   MOD
+MODIFIES       NATURAL         NOT
+NO_WRITE_TO_BINLOG     NULL    NUMERIC
+ON     OPTIMIZE        OPTION
+OPTIONALLY     OR      ORDER
+OUT    OUTER   OUTFILE
+PRECISION      PRIMARY         PROCEDURE
+PURGE  RANGE   READ
+READS  READ_WRITE      REAL
+REFERENCES     REGEXP  RELEASE
+RENAME         REPEAT  REPLACE
+REQUIRE        RESIGNAL        RESTRICT
+RETURN         REVOKE  RIGHT
+RLIKE  SCHEMA  SCHEMAS
+SECOND_MICROSECOND     SELECT  SENSITIVE
+SEPARATOR      SET     SHOW
+SIGNAL         SLOW    SMALLINT
+SPATIAL        SPECIFIC        SQL
+SQLEXCEPTION   SQLSTATE        SQLWARNING
+SQL_BIG_RESULT         SQL_CALC_FOUND_ROWS     SQL_SMALL_RESULT
+SSL    STARTING        STRAIGHT_JOIN
+TABLE  TERMINATED      THEN
+TINYBLOB       TINYINT         TINYTEXT
+TO     TRAILING        TRIGGER
+TRUE   UNDO    UNION
+UNIQUE         UNLOCK  UNSIGNED
+UPDATE         USAGE   USE
+USING  UTC_DATE        UTC_TIME
+UTC_TIMESTAMP  VALUES  VARBINARY
+VARCHAR        VARCHARACTER    VARYING
+WHEN   WHERE   WHILE
+WITH   WRITE   XOR
+YEAR_MONTH     ZEROFILL         
+
+The following are new reserved words in MySQL 5.5:
+GENERAL        IGNORE_SERVER_IDS       MASTER_HEARTBEAT_PERIOD
+MAXVALUE       RESIGNAL        SIGNAL
+SLOW            
+
+MySQL permits some keywords to be used as unquoted identifiers because many people previously used them. Examples are those in the following list:
+
+    *
+
+      ACTION
+    *
+
+      BIT
+    *
+
+      DATE
+    *
+
+      ENUM
+    *
+
+      NO
+    *
+
+      TEXT
+    *
+
+      TIME
+    *
+
+      TIMESTAMP
+