mybatis删除语句
- 作者: 阳光下歇斯底里的轻笑22817050
- 来源: 51数据库
- 2020-09-21
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>
解决办法：直接写多条delete语句
[html]?view plain?copy
推荐阅读
