Mybatis MySQL allowMultiQueries 一次性执行多条语句

最新推荐文章于 2025-06-26 11:52:20 发布

MyFreeIT

最新推荐文章于 2025-06-26 11:52:20 发布

阅读量750

点赞数 1

CC 4.0 BY-SA版权

分类专栏：数据库文章标签： mybatis mysql android

创作源自于MyFreeIT

本文链接：https://blog.youkuaiyun.com/MyFreeIT/article/details/139868531

数据库专栏收录该内容

58 篇文章

订阅专栏

在JDBC 增加参数allowMultiQueries

jdbc:mysql://localhost:3306/abc?++++++++++++++&allowMultiQueries=true

<insert id="addRi" parameterType="java.util.List">
    
DELETE FROM sys_ri  WHERE sr_id = #{roId}  AND sr_fion_id = #{fod};
    	
    	
INSERT into sys_r
    	
VALUES
    	
<foreach collection ="rlisssst" item="item" index="index" separator=",">
  (#{item.id},#{item.rd})
</foreach>
</insert>

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 'INSERT into sys_ri VALUES (0,17,11, 'In' at line 4