有时想把多行数据合并成一行，比如多个系统订单号对应一个外部订单号。
想实现下面的效果
就可以用group_concat
SELECT
GROUP_CONCAT(id SEPARATOR ',')) AS ERP单号,
outOrderNo AS 外单号
FROM
`order`
WHERE
outOrderNo IN ('xxxxxxx')
AND isDelete = 0
GROUP BY
outOrderNo
ORDER BY
outOrderNo ASC版权声明：本文为UESTC312原创文章，遵循CC 4.0 BY-SA版权协议，转载请附上原文出处链接和本声明。