sername,'语文' as subject,"语文" as score from ScoresStudent www.2cto.com
union
select username,'数学' as subject,"数学" as score from ScoresStudent
union
select username,'英语' as subject,"英语" as score from ScoresStudent
union
select username,'生物' as subject,"生物" as score from ScoresStudent;
作者 cupid1102