(一)小小的一次记载. (二):最近的项目都是使用MyBatis,批量新增自己都会写了,但是一次批量删除可把我给折腾了下,写法网上都有,但是照着做就是不行,最后问公司的人,问网友才得到答案,那就是jdbc中需要在url中指定允许进行进行多条语句同时执行. 自己在写批量更新的时候也把相应的语句打印出来了的,复制出来执行是没问题,但是用junit测试的时候一直报错如下 Error code 1064, SQL state 42000: You have an error in your SQL sy
<!--==========================删除==================================== --> <delete id="delete" parameterType="list"> <![CDATA[ delete t_vehicle_motorcade where fid in ]]> <foreach c
<delete id="deleteByStandardIds"> delete from t_standard_catalog where standard_id in <foreach collection="array" item="standardId" open="(" close=")" separator=","> #{standardId,jdbc
<deleteid="deleteCTQ" parameterType="java.lang.String"> DELETE FROM sqm_product_ctq_current where guid in <foreach item="idItem"collection="array"open="("separator=","close=")"
<deleteid="deleteCTQ" parameterType="java.lang.String"> DELETE FROM sqm_product_ctq_current where guid in <foreach item="idItem"collection="array"open="("separator=","close=")"
mapper.xml: <update id="delete" parameterType="int"> delete from user_login where id in <foreach item="ids" collection="array" open="(" separator="," close=")"> #{ids} </