关于mysql的行转列问题
一张表，里面有? id? name?? state??? customerid 4个字段，其中status有3个值0 1 2 ，用一条sql查询出此种格式
select customid, count(case status when 0 then status else null end) as status-0, count(case status when 1 then status else null end) as status-1, count(case status when 2 then status else null end) as status-2 from custom group by customid.?
?
