mysql 统计每列即每个字段下的0,1，-1的个数

Question

问题已经解决

数据如图，我想求这个表中每个字段下0，1，-1的个数，即 air-control-type下有多少个0，多少个1，多少个-1；air-independent-back 下 0，1，-1的个数。。。。

注意效率，一条语句跑完最好

Answer 1

SELECT COUNT(CASE WHEN (A.air-control-type=0) THEN 0 END),
COUNT(CASE WHEN (A.air-control-type=1) THEN 0 END),
COUNT(CASE WHEN (A.air-control-type=-1) THEN 0 END),
COUNT(CASE WHEN (A.air-independent-back=0) THEN 0 END),
COUNT(CASE WHEN (A.air-independent-back=1) THEN 0 END),
COUNT(CASE WHEN (A.air-independent-back=-1) THEN 0 END)
FROM T_TABLE AS S