数据表范例:date type
---------------------
2010-08-05 a
2010-08-05 a
2010-08-05 a
2010-08-05 b
2010-08-05 c
2010-08-05 c
2010-08-06 a
2010-08-06 b
2010-08-06 c
2010-08-06 c
要求查询结果样式:date count(type=a) count(type=b) count(type=c)
---------------------------------------------------------------
2010-08-05 3 1 1
2010-08-06 1 1 2
---------------------
2010-08-05 a
2010-08-05 a
2010-08-05 a
2010-08-05 b
2010-08-05 c
2010-08-05 c
2010-08-06 a
2010-08-06 b
2010-08-06 c
2010-08-06 c
要求查询结果样式:date count(type=a) count(type=b) count(type=c)
---------------------------------------------------------------
2010-08-05 3 1 1
2010-08-06 1 1 2
sum(if(`type`='a',1,0)) as `count(type=a)`,
sum(if(`type`='b',1,0)) as `count(type=b)`,
sum(if(`type`='c',1,0)) as `count(type=c)`
from 数据表范例
group by `date`