文章地址:https://www.cnblogs.com/xiaoxi/p/7151433.html
7、合并字段显示:利用group_concat()
SELECT userid,GROUP_CONCAT(`subject`,":",score)AS 成绩 FROM tb_score
GROUP BY userid;
运行结果:
文章地址:https://www.cnblogs.com/xiaoxi/p/7151433.html
7、合并字段显示:利用group_concat()
SELECT userid,GROUP_CONCAT(`subject`,":",score)AS 成绩 FROM tb_score
GROUP BY userid;
运行结果: