diff options
Diffstat (limited to 'etc/sql-reserved-words.txt')
| -rw-r--r-- | etc/sql-reserved-words.txt | 113 |
1 files changed, 113 insertions, 0 deletions
diff --git a/etc/sql-reserved-words.txt b/etc/sql-reserved-words.txt index dc507ce..89dea74 100644 --- 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 + +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 + |