表Aid name age1 x 22
2 y 21
3 y 3
4 x 32
5 z 2
6 y 24表Bname sex
x man
y woman
z man删除A表中count(name) > 2的记录的同时删除表B里面name和A中name相同的数据得到id name age1 x 22
4 x 32
5 z 2
name sexx man
z man
2 y 21
3 y 3
4 x 32
5 z 2
6 y 24表Bname sex
x man
y woman
z man删除A表中count(name) > 2的记录的同时删除表B里面name和A中name相同的数据得到id name age1 x 22
4 x 32
5 z 2
name sexx man
z man
delete from tta a WHERE 2>(SELECT COUNT(*) FROM tta WHERE a.name=NAME)delete b from b left join tta on b.name=tta.name where tta.name is null
delete from b where name in (select name from (select count(name) count,name from a group by name) c where c.count>2);