<update id="setGroupIdIsNull" parameterType="java.util.List">
UPDATE bx_well_water_ability SET water_ability_group_id = NULL WHERE 1=1
AND water_ability_group_id in
<foreach collection="waterAbilityGroupId" item="id" open="(" close= ")" separator=",">
${id}
</foreach>
</update>