table name :testid name stat
1 haha 0
2 haha 1
3 gege 0
4 gege 2
5 tete 1
6 gege 2
----------------------------------
我想显示这个视图
name stat=0 stat=1 stat=2
haha 1 1 0
gege 1 0 2
tete 0 1 0
----------------------------------
mysql 请问怎么写。谢谢
1 haha 0
2 haha 1
3 gege 0
4 gege 2
5 tete 1
6 gege 2
----------------------------------
我想显示这个视图
name stat=0 stat=1 stat=2
haha 1 1 0
gege 1 0 2
tete 0 1 0
----------------------------------
mysql 请问怎么写。谢谢
sum(if(stat=0,1,0)) as `stat=0`,
sum(if(stat=1,1,0)) as `stat=1`,
sum(if(stat=2,1,0)) as `stat=2`
from test
group by name
MySQL交叉表