mybatis中循环更新数据的SQL语句

一、 同时更新多条数据的同一个字段的同一个值

<update id="updatePicturePostId">
    update bbs_pictures set post_id = #{postId} 
    where  user_id = #{userId} and picture_name in
    (<foreach collection="pictureName" item="item" separator="," >
          #{item}
    </foreach>)
</update>

二、 同时更新多条数据的同一个字段的不同值

<update id="updatePicturePostId">
    <foreach collection="pictureName" item="item" separator="," >
         update bbs_pictures set post_id = #{item.id}
    	 where  user_id = #{userId} and picture_name in #{item.name}
    </foreach>)
</update>