mysql命令

select ip,count(*) as count from interface group by ip having count>1;
查看 interface表中 ip字段重复的

select ip,count(*) as count from interface where port = "10050" group by ip having count>1;
增加条件