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
执行结果