#默认分隔符为“,”
SELECT `name`,GROUP_CONCAT(score) AS score FROM scores GROUP BY `name`;
#使用“-”作为分隔符
SELECT `name`,GROUP_CONCAT(score separator "-") AS score FROM scores GROUP BY `name`;
#对score进行排序
SELECT `name`,GROUP_CONCAT(score ORDER BY score separator "-") AS score FROM scores GROUP BY `name`;
#连接多个字段
SELECT `name`,GROUP_CONCAT(course,"-",score ORDER BY score separator "|") AS score FROM scores GROUP BY `name`;
#使用concat_ws函数
SELECT `name`,GROUP_CONCAT(concat_ws("-",course,score) ORDER BY score separator "|") AS score FROM scores GROUP BY `name`;
Mysql将分组后产生的同一分组的值连接起来
最新推荐文章于 2023-07-26 08:49:00 发布