SELECT fieldname1,GROUP_CONCAT(distinct fieldname2 ORDER BY fieldname2 SEPARATOR ',') FROM table GROUP BY fieldname1
Mysql多行合并一行
最新推荐文章于 2023-06-27 15:41:16 发布
SELECT fieldname1,GROUP_CONCAT(distinct fieldname2 ORDER BY fieldname2 SEPARATOR ',') FROM table GROUP BY fieldname1