mysql命令

发布时间：2022-07-04 12:39 所属栏目：115 来源：互联网

导读：select ip,count(*) as count from interface group by ip having count1; 查看 interface表中 ip字段重复的 select ip,count(*) as count from interface where port = 10050 group by ip having count1; 增加条件

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