工作中常用mysql语句

梅举字段重复个数

SELECT gid,COUNT(0) from im_pull_group_sync GROUP  BY gid

查询字段有重复的项

select nickname,count(*) as count from im_user group by nickname having count>’1‘   （1是两个重复，，2是有3个重复）

查询表A中im_unique_id等于表B中的id 且reserved=0 len=000006的数据

SELECT * from im_unique_id where reserved=0 and len=000006 and id in (SELECT id from tables)