MySQL保留字(关键字)
经常会遇到这样的问题，在MySQL里面建立了一个Table，定义了一些字段，但在使用MySQL的时候，跑程序怎样都调不通。其实很多时候是我们所定义的字段名是MySQL的保留字（关键字）。在网上查了一下，把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 |
|
|