问题
在走接口的时候,需要使用mybtatis的批量更新,偷了个懒使用Foreach的形式拼接多个sql语句进行更新。结果在执行到这个sql的时候update一直报错
### Error updating database. Cause: java.sql.SQLSyntaxErrorException: 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 'update xxxxxxxxxxxxxxxxx at line 1 ### The error may exist in xxxxxxxxx.java (best guess) ### The error may involve xxxxxxxxxx.someaction-Inline ### The error occurred while setting parameters ### SQL: update xxxxxxxxxxxxxxx ### Cause: java.sql.SQLSyntaxErrorException: 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 'update invoice_check set company_id = '1132',pch = '2021050610191505316062112345' at line 1\n; bad SQL grammar []; nested exception is java.sql.SQLSyntaxErrorException: 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 'update xxxxxxxxxxxxxxx at line 1
让我检查update左侧的语句,而左侧的语句是;
,怎么会出问题,于是将sql打印出来查看
update xxx set xxx = xxx where id = x ; update xxx set xxx = xxx where id = x
直接扔到navicat里执行无误,但是在程序中就挂掉了
解决方案
在jdbc中加上一句
&allowMultiQueries=true
就解决了
例如
jdbc:mysql://localhost/test?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8&useAffectedRows=true&allowMultiQueries=true
标签:xxx,update,syntax,报错,带分,error,your,### From: https://www.cnblogs.com/xingmeng63/p/17259083.html