1.up.menu_id 是单个
SELECT p.*
FROM user_info AS ui
JOIN power AS up ON ui.type_id = up.type_id
JOIN menu AS p ON up.menu_id = p.m_id
WHERE ui.user_id = 1;
2.up.menu_id 是数组
SELECT p.*
FROM user_info AS ui
JOIN power AS up ON ui.type_id = up.type_id
JOIN menu AS p ON FIND_IN_SET(p.m_id, up.menu_id) > 0
WHERE ui.user_id = 1;
3.order字段正序排
SELECT p.*
FROM user_info AS ui
JOIN power AS up ON ui.type_id = up.type_id
JOIN menu AS p ON FIND_IN_SET(p.m_id, up.menu_id) > 0
WHERE ui.user_id = 1 ORDER BY p.order ASC;
4.order字段倒叙
SELECT p.*
FROM user_info AS ui
JOIN power AS up ON ui.type_id = up.type_id
JOIN menu AS p ON FIND_IN_SET(p.m_id, up.menu_id) > 0
WHERE ui.user_id = 1 ORDER BY p.order DESC;
文章介绍了如何根据单个或数组菜单ID查询用户权限,并按order字段排序,包括正序和倒序两种情况的SQL查询语句。
2万+

被折叠的 条评论
为什么被折叠?



