a0701302的专栏

group_concat的默认分隔符是“,”，若要改为其他分隔符，则使用SEPARATOR来指定，例如：mysql> SELECT student_id, GROUP_CONCAT(courses_id SEPARATOR '@#$') AS courses FROM student_courses WHERE student_id=2 GROUP BY student_id; 除