SELECT
stu_name,
course,
MAX(CASE WHEN (course = 'Java') THEN score ELSE 0 END) Java,
MAX(CASE WHEN (course = 'Html') THEN score ELSE 0 END) Html,
MAX(CASE WHEN (course = 'Jsp') THEN score ELSE 0 END) Jsp,
MAX(CASE WHEN (course = 'Spring') THEN score ELSE 0 END) Spring
FROM score
GROUP BY stu_name;
GROUP BY没有写全SELECT的项,加上course就好
也可以更改only_full_group_by配置