有时想把多行数据合并成一行,比如多个系统订单号对应一个外部订单号。
想实现下面的效果
就可以用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
有时想把多行数据合并成一行,比如多个系统订单号对应一个外部订单号。
想实现下面的效果
就可以用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