mysql 通过查询条件查出指定字段记录数。

SELECT ip_name,count(ip_name) as ipcount from IP GROUP BY ip_name where ipcount >1; 本以为可以像在MSsql一样现在，发现不行，下面是在Mysql方法 SELECT ip_name,count(ip_name) as ipcount from IP GROUP BY ip_name having count(ip_name)>1;

 

转载于:https://www.cnblogs.com/yixiong/archive/2012/07/18/2597127.html