sql 语句(mybatis)
DELETE FROM xxx t where id = #{id}
and type in
<foreach collection="types" item="type" index="index" open="(" close=")" separator=",">
#{type}
</foreach>
表名后面不能有 t
sql 语句(mybatis)
DELETE FROM xxx t where id = #{id}
and type in
<foreach collection="types" item="type" index="index" open="(" close=")" separator=",">
#{type}
</foreach>
表名后面不能有 t