关于Mysql数据表行转列

Answer 1

试试下面的语句：

select team_name,sum(if(score='正',1,0)) as'正',sum(if(score='负',1,0)) as '负' 
from teamscore 
group by team_name;

Answer 2

应该是：

SELECT team_name, count(*) AS win WHERE score = '正' GROUP BY team_name
SELECT team_name, count(*) AS loss WHERE score = '负' GROUP BY team_name

再想办法把这两个结果合起来。