SELECT
*
FROM
sys_role sr,
sys_role_user sru,
sys_user su
WHERE
su.id = sru.sys_user_id
AND sru.sys_role_id = sr.id
AND su.username = 'admin';
SELECT
sr.*
FROM
sys_role_user sru
LEFT JOIN sys_role sr ON sr.id = sru.sys_role_id
SELECT
su.`username`,
sr.`name`
FROM
sys_user su
LEFT JOIN sys_role_user sru ON su.id = sru.sys_user_id
LEFT JOIN sys_role sr ON sr.id = sru.sys_role_id
WHERE
su.username = 'admin';```
一些SQL语句
于 2022-03-19 17:12:12 首次发布