mysql 一对多查询 多个返回结果单行显示
select r.roleId, r.roleName ,GROUP_CONCAT(p.permissionDescription SEPARATOR ' ') as permissionName from t_permission p , role_permission rp ,
t_role r where r.roleId=rp.roleId and rp.permissionId=p.permissionId
GROUP BY r.roleId
避免这种情况 返回值为null 将结果显示出来
select r.roleId, r.roleName ,GROUP_CONCAT(p.permissionDescription SEPARATOR ' ') as permissionName from t_permission p , role_permission rp ,
t_role r where r.roleId=rp.roleId and rp.permissionId=p.permissionId
GROUP BY r.roleId