MySQL COUNT加统计条件

COUNT((('字段名' = '条件') OR NULL)) 

-- 列子如下 在IP段列表显示下面IP总数量,空闲数量,故障数量
SELECT A.*,COUNT(B.id) AS totalip,COUNT(((B.use_status = 1) OR NULL)) AS idleip,COUNT(((B.use_status = 4) OR NULL)) AS faultip 
FROM icab_ipsegment AS A
LEFT JOIN icab_ip AS B ON A.id = B.ipsegment_id
GROUP BY A.id

执行结果

 

 页面显示

 

posted @ 2020-10-27 17:56  $Elvin  阅读(2214)  评论(0)    收藏  举报