MySql中关键字

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

ADD ANALYZE ASC BETWEEN BLOB CALL CHANGE CHECK CONDITION CONTINUE CROSS CURRENT_TIMESTAMP DATABASE DAY_MICROSECOND DEC DEFAULT DESC DISTINCT DOUBLE EACH ENCLOSED EXIT FETCH FLOAT8 FOREIGN ALL AND ASENSITIVE BIGINT BOTH CASCADE CHAR COLLATE CONNECTION CONVERT CURRENT_DATE CURRENT_USER DATABASES DAY_MINUTE DECIMAL DELAYED DESCRIBE DISTINCTROW DROP ELSE ESCAPED EXPLAIN FLOAT FOR FROM ALTER AS BEFORE BINARY BY CASE CHARACTER COLUMN CONSTRAINT CREATE CURRENT_TIME CURSOR DAY_HOUR DAY_SECOND DECLARE DELETE DETERMINISTIC DIV DUAL ELSEIF EXISTS FALSE FLOAT4 FORCE FULLTEXT GOTO HAVING HOUR_MINUTE IGNORE INFILE INSENSITIVE INT1 INT4 INTERVAL ITERATE KEYS LEADING LIKE LINES LOCALTIMESTAMP LONGBLOB LOW_PRIORITY MEDIUMINT MODIFIES ON OPTIONALLY OUT PRECISION PURGE READ REFERENCES RENAME REQUIRE REVOKE SCHEMA SELECT SET GRANT HIGH_PRIORITY HOUR_SECOND IN INNER INSERT INT2 INT8 INTO JOIN KILL LEAVE LIMIT LOAD LOCK LONGTEXT MATCH MEDIUMTEXT NATURAL OPTIMIZE OR OUTER PRIMARY RAID0 READS REGEXP REPEAT RESTRICT RIGHT SCHEMAS SENSITIVE SHOW GROUP HOUR_MICROSECOND IF INDEX INOUT INT INT3 INTEGER IS KEY LABEL LEFT LINEAR LOCALTIME LONG LOOP MEDIUMBLOB MIDDLEINT MOD NOT NUMERIC OPTION ORDER OUTFILE PROCEDURE RANGE REAL RELEASE REPLACE RETURN RLIKE SECOND_MICROSECOND SEPARATOR SMALLINT MINUTE_MICROSECOND MINUTE_SECOND NO_WRITE_TO_BINLOG NULL SPATIAL SQLEXCEPTION SQL_BIG_RESULT SSL TABLE TINYBLOB TO TRUE UNIQUE UPDATE USING UTC_TIMESTAMP VARCHAR WHEN WITH XOR SPECIFIC SQLSTATE STARTING TERMINATED TINYINT TRAILING UNDO UNLOCK USAGE UTC_DATE VALUES VARCHARACTER WHERE WRITE YEAR_MONTH SQL SQLWARNING STRAIGHT_JOIN THEN TINYTEXT TRIGGER UNION UNSIGNED USE UTC_TIME VARBINARY VARYING WHILE X509 ZEROFILL SQL_CALC_FOUND_ROWS SQL_SMALL_RESULT 除MySQL允许部分关键字用做未引起来的识别符，因为许多人以前曾使用过它们。下面列出了一些例子： ACTION BIT DATE ENUM NO TEXT TIME TIMESTAMP