SQL点滴积累3--detete 删除的目标表数据与其他表有关联关系
删除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 ***