MySQL group_concat跟concat_ws使用(分组后连接字符串)

SELECT
    group_concat(
        DISTINCT concat_ws(
            '',
            concat_ws(
                '|',
                ip_id,
                is_primary,
                A.note,
                B.ip
            )
        )
    )
FROM
    common_device_intranet_ip_relation AS A
LEFT JOIN common_idc_intranetip AS B ON A.ip_id = B.id
WHERE
    device_connect_id = 767
GROUP BY
    ipsegment_use_type,
    ipsegment_group_id,
    A.ipsegment_id
 
执行结果
 
posted @ 2021-03-09 14:43  $Elvin  阅读(114)  评论(0)    收藏  举报