mysql查重：

单字段

1
select * from member where mobile in (select mobile from member group by mobile  having count(mobile) > 1)

单字段查重删除

1
delete from member where mobile in (select mobile from member group by mobile   having count(mobile) > 1) and rowid not in (select min(rowid) from member group by mobile having count(mobile)>1)

多字段

1
select * from member a where (a.mobile,a.email) in (select mobile,email from member group by mobile,email having count(*) > 1)

多字段查重删除

1
delete from member a where (a.mobile,a.email) in (select mobile,email from member group by mobile,email having count(*) > 1) and rowid not in (select min(rowid) from member group by mobile,email having count(*)>1)