mysql静的縦表変横表

Create table Class([Student] nvarchar(2),[Course] nvarchar(2),[Score] int) Insert Class select N'  ',N'  ',78 union all select N'  ',N'  ',87 union all select N'  ',N'  ',82 union all select N'  ',N'  ',90 union all select N'  ',N'  ',65 union all select N'  ',N'  ',77 union all select N'  ',N'  ',65 union all select N'  ',N'  ',85 Go select [Student], [  ]=max(case when [Course]='  ' then [Score] else 0 end), [  ]=max(case when [Course]='  ' then [Score] else 0 end), [  ]=max(case when [Course]='  ' then [Score] else 0 end), [  ]=max(case when [Course]='  ' then [Score] else 0 end) from Class group by [Student]