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;
增加条件
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;
增加条件