Translating SQLException with SQL state '42000', error code '1064&apo

2018-01-31 10:59:40来源:oschina作者:卯金刀GG人点击

分享

保存修改的时候,mybatis始终报4200错误,最后发现用了mysql的保留字 before,after

[org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator]-TranslatingSQLExceptionwithSQLstate'42000',errorcode'1064',message[YouhaveanerrorinyourSQLsyntax;checkthemanualthatcorrespondstoyourMySQLserverversionfortherightsyntaxtousenear'before) values('text',

mysql保留字参考如下:


http://luanxiyuan.iteye.com/blog/2224331


你不小心使用了下面的关键字 那么就会报这个错误


“SQL Error: 1064, SQLState: 42000错误”



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

最新文章

123

最新摄影

微信扫一扫

第七城市微信公众平台