mybatis insert values后面多了空格导致sql报错，用的是mysql数据库

Question

Error updating database. Cause: 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 '  

(1,1)' at line 2

The error may involve com.ejoined.octopus.server.pc.dao.GoodsDao.insertGoodsSku-Inline

The error occurred while setting parameters

SQL: INSERT INTO GM_GOODS_SKU_REL(GOODS_ID,SKU_ID) VALUES    (?,?)

Cause: 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 '  

(1,1)' at line 2
]

Answer 1

错误提示的很明显，是你的语法有问题，仔细检查下你的sql语句。
或者把你的sql贴出来，大家帮你看看。

参考自：
MySQL insert用法详解 http://www.data.5helpyou.com/article421.html