Posted on 2007-04-22 23:34
qiyadeng 閱讀(2885)
評(píng)論(1) 編輯 收藏
今天在調(diào)試程序中發(fā)現(xiàn)類(lèi)似下面這種錯(cuò)誤
- SQL Error: 1064, SQLState: 42000- You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'REQUIRE, PLAN_DATE, COMPILE, AUDITOR, AGREE_PERSON, AGREE_DATE, ADD_BY, MOD_BY, ' at line 1- Could not synchronize database state with sessionorg.hibernate.exception.SQLGrammarException: Could not execute JDBC batch update
找了半天也沒(méi)發(fā)現(xiàn)是什么錯(cuò)誤,搜索多數(shù)認(rèn)為是 hbm.xml中catalog中引起的問(wèn)題，但我檢查了發(fā)現(xiàn)不是配置文件引起的問(wèn)題。后來(lái)聯(lián)想到是不是MySQL的保留字的問(wèn)題，找到http://dev.mysql.com/doc/refman/5.1/zh/language-structure.html#reserved-words，果然是。
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 |
| 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 |