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 (1092750
9,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