MySQL数据库将多条记录的单个字段合并成一条记录

复制代码
SELECT acc.id,acc.acc_username,acc.acc_showname,GROUP_CONCAT(T_PM_ROLE.role_name) FROM  T_ACCOUNT acc,T_ACCOUNT_R_ROLE accRole ,T_PM_ROLE  WHERE acc.is_active =1 AND (accRole.is_active =1 AND  acc.id = accRole.acc_id) AND accRole.role_id = T_PM_ROLE.id
 
GROUP BY acc_id
  
ORDER BY acc.id  

GROUP_CONCAT 和 GROUP BY 结合使用