表结构
1.使用union
select name,'语文',chinese'grade' from TestGrade
union
select name,'英语',english'grade' from TestGrade
union
select name,'数学',`match`'grade' from TestGrade
order by name
表结构
select name,'语文',chinese'grade' from TestGrade
union
select name,'英语',english'grade' from TestGrade
union
select name,'数学',`match`'grade' from TestGrade
order by name