SELECT name, GROUP_CONCAT(course, ":", score) AS 成绩 FROM student GROUP BY name; 合并一定要写GROUP BY 转 https://www.cnblogs.com/thomas12112406/p/5813394.html