1.使用group_concat()未去除重复时语句
SELECT
group_concat(s.driver_id SEPARATOR ',' ) AS driverIds
FROM
t_order_split s
查询结果
2.使用group_concat()去除重复数据语句
SELECT
group_concat( DISTINCT s.driver_id SEPARATOR ',' ) AS driverIds
FROM
t_order_split s
查询结果