mysql查重笔记

select count(*) as count, mobile from user group by mobile having count  > 1;