mybatis delete标签

Question

<delete id="deleteByPrimaryKey" parameterType="java.lang.Integer">
delete from news
where id = #{id,jdbcType=INTEGER};
delete from news_info
where news_id = #{id,jdbcType=INTEGER};
</delete>
不可以执行吗 SQL 命令为正确结束

Answer 1

mybatis在一个delete标签写多条delete语句

解决办法：直接写多条delete语句

[html] view plain copy

<delete id="deleteComboInfo">  

delete from amb_pairs where id in  

<foreach collection="id.split(',')" close=")" open="(" separator="," item="item">  

#{item}  

</foreach>  

;  

delete from amb_pair_detail where pair_id in  

<foreach collection="id.split(',')" close=")" open="(" separator="," item="item">  

#{item}  

</foreach>  

;  

</delete>