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 ***