删除a表中与b表重复的数据
1)delete from a where exists (select * from b where ***)
2)delete from a from a inner join b on a.id=b.id where ***
删除a表中与b表重复的数据
1)delete from a where exists (select * from b where ***)
2)delete from a from a inner join b on a.id=b.id where ***
转载于:https://www.cnblogs.com/mifeng/p/3259336.html