mysql GROUP_CONCAT多行合并为一条记录
摘要:select uir.account, GROUP_CONCAT(r.name SEPARATOR ',') as roles from kt_user_info_role uir left join kt_sys_role r on uir.role_id = r.id GROUP BY uir.
阅读全文
posted @ 2021-03-16 14:15
posted @ 2021-03-16 14:15
posted @ 2021-03-07 08:28
posted @ 2021-03-04 09:45