select name,'语文'as subject,China as number from student
UNIONselect name,'数学'as subject,Math as number from student
UNIONselect name,'英语'as subject,english as number from student
UNIONselect name,'体育'as subject,sports as number from student
转换前转换后select name,'语文' as subject,China as number from studentUNION select name,'数学' as subject,Math as number from studentUNION select name,'英语' as subject,english as number from studentUNION select name,'体育' as subject,sports as number from