SELECT
a.SERVICE_ID,
a.SERVICE_NAME,
(
SELECT
GROUP_CONCAT(b.IP_ADDRESS)
FROM
t_sys_service_ip b
WHERE
a.SERVICE_ID = b.SERVICE_ID
),
(
SELECT
GROUP_CONCAT(c.USER_NAME,',', c.`PASSWORD` SEPARATOR '|')
FROM
t_sys_service_user c
WHERE
a.SERVICE_ID = c.SERVICE_ID
)
FROM
t_sys_service a;
---------------------
作者:布丰
来源:CSDN
原文:https://blog.csdn.net/songanling/article/details/64129979?utm_source=copy
版权声明:本文为博主原创文章,转载请附上博文链接!
mysql的多字段合并函数的用法
最新推荐文章于 2024-04-11 10:20:17 发布