摘要:
需求描述:A、B两表,找出ID字段中,存在A表,但是不存在B表的数据。1、方法一(推荐):逻辑相对复杂,但是速度最快 ~执行时间: 0.570秒~select * from B where (select count(1) as num from A where A.ID = B.ID) = 0 2 阅读全文
摘要:
1、批量删除 <delete id="deleteLanguageBatch"> delete from user where <foreach collection="list" item="item" separator="or"> id = #{item.id} name = #{item.n 阅读全文