jdbc 語句 mysql關鍵字

jdbc 的 sql語句遇到了關鍵字

- TIME      = 2013-05-29 03:10:36.0- SOURCEID  = SUBWAY-M2M-TF-8- POSITION  = 002228:0203272686#363623406.1369768236- VARIABLE:- SCHEMA = subway_p31- TABLE = lunabidsetting- ACTION = INSERT - ROW# = 1   COL#1: CAMPAIGNID(-5) = 10927509   COL#2: CUSTID(-5) = 1103845351   COL#3: KEYS(12) = BidDailyMaxCost   COL#4: OLDVALUE(-5) = -1   COL#5: NEWVALUE(-5) = 3000   COL#6: CREATETIME(93) = 2013-05-29 03:10:36.0   COL#7: LASTUPDATETIME(93) = 2013-05-29 03:10:36.0

com.taobao.tddl.dbsync.applier.ApplierBrokenException: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: 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 'keys,oldvalue,newvalue,createtime,lastupdatetime) VALUES (10927509,1103845351,'B' at line 1

目標表的列名是關鍵字，需要加反引號 `keys`

sql server 加中括弧

insert into app (name,`key`,secret,status) values ('aa','bb',null,2); 

參考 http://solodu.iteye.com/blog/520419