花开花谢，人来又走，夕阳西下，人去楼空，早已物是人非矣。也许，这就是结局，可我不曾想过结局是这样;也许，这就是人生的意义，可我不曾想竟是生离死别。
在使用 php + mysql 程序时，有时候定义的数据表的字段会和 mysql 的关键字发生冲突，造成程序无法运行的错误。而这种错误最典型的就是“SQL Error: 1064, SQLState: 42000错误”。为了防止此错误的出错，下面列出了一些 mysql 的关键字。
mysql 关于关键字冲突的错误
SQL Error: 1064, SQLState: 42000错误
MySQL server version for the right syntax to use near
mysql 关键字表
| 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 | CONNECTION |
| 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 | GOTO |
| GRANT | GROUP |
| HAVING | HIGH_PRIORITY |
| HOUR_MICROSECOND | HOUR_MINUTE |
| HOUR_SECOND | IF |
| IGNORE | IN |
| INDEX | INFILE |
| INNER | INOUT |
| INSENSITIVE | INSERT |
| INT | INT1 |
| INT2 | INT3 |
| INT4 | INT8 |
| INTEGER | INTERVAL |
| INTO | IS |
| ITERATE | JOIN |
| KEY | KEYS |
| KILL | LABEL |
| LEADING | LEAVE |
| LEFT | LIKE |
| LIMIT | LINEAR |
| LINES | LOAD |
| LOCALTIME | LOCALTIMESTAMP |
| LOCK | LONG |
| LONGBLOB | LONGTEXT |
| LOOP | LOW_PRIORITY |
| MATCH | MEDIUMBLOB |
| MEDIUMINT | MEDIUMTEXT |
| MIDDLEINT | MINUTE_MICROSECOND |
| MINUTE_SECOND | MOD |
| MODIFIES | NATURAL |
| NOT | NO_WRITE_TO_BINLOG |
| NULL | NUMERIC |
| NUMERIC | ON |
| OPTIMIZE | OPTION |
| OPTIONALLY | OR |
| ORDER | OUT |
| OUTER | OUTFILE |
| PRECISION | PRIMARY |
| PROCEDURE | PURGE |
| RAID0 | RANGE |
| READ | READS |
| REAL | REFERENCES |
| REGEXP | RELEASE |
| RENAME | REPEAT |
| REPLACE | REQUIRE |
| RESTRICT | RETURN |
| REVOKE | RIGHT |
| RLIKE | SCHEMA |
| SCHEMAS | SECOND_MICROSECOND |
| SELECT | SENSITIVE |
| SEPARATOR | SET |
| SHOW | 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 |
| X509 | XOR |
| YEAR_MONTH | ZEROFILL |
以上就是mysql 关键字一览表。与狼共舞，必须自己成为狼，而且变成“超级狼”。更多关于mysql 关键字一览表请关注haodaima.com其它相关文章！
