25 lines
777 B
MySQL
25 lines
777 B
MySQL
|
-- 分析心理测评管理的完整配置，作为参考
|
||
|
|
|
||
|
|
-- 1. 查看心理测评管理（顶级菜单）的配置
|
||
|
|
SELECT menu_id, menu_name, parent_id, path, component, menu_type, visible
|
||
|
|
FROM sys_menu
|
||
|
|
WHERE menu_id = 2009;
|
||
|
|
|
||
|
|
-- 2. 查看心理测评管理下的子菜单
|
||
|
|
SELECT menu_id, menu_name, parent_id, path, component, menu_type, order_num
|
||
|
|
FROM sys_menu
|
||
|
|
WHERE parent_id = 2009
|
||
|
|
ORDER BY order_num;
|
||
|
|
|
||
|
|
-- 3. 对比：查看心理网站管理（顶级菜单）的配置
|
||
|
|
SELECT menu_id, menu_name, parent_id, path, component, menu_type, visible
|
||
|
|
FROM sys_menu
|
||
|
|
WHERE menu_id = 2000;
|
||
|
|
|
||
|
|
-- 4. 查看心理网站管理下的子菜单
|
||
|
|
SELECT menu_id, menu_name, parent_id, path, component, menu_type, order_num
|
||
|
|
FROM sys_menu
|
||
|
|
WHERE parent_id = 2000
|
||
|
|
ORDER BY order_num
|
||
|
|
LIMIT 3;
|