https://www.cnblogs.com/ClassNotFoundException/p/6860615.html
列转行:利用max(case when then)
SELECT `name`,
MAX(CASE WHEN course='语文' THEN score END) AS 语文,
MAX(CASE WHEN course='数学' THEN score END) AS 数学,
MAX(CASE WHEN course='英语' THEN score END) AS 英语
FROM student
GROUP BY `name`
;