查询所有上级和所有下级
-- 查询自己和所有上级SELECT T0.*, T1.dept_name, T1.parent_idFROM ( SELECT @r AS _id, ( SELECT @r := parent_id FROM sys_dept WHERE dept_id = _id ) AS parent_id1, @l := @l + 1 AS lvl FROM ( SELECT @r := '103', @l := 0 ) vars, sys_dept h WHERE .
原创
2021-11-13 08:37:49 ·
978 阅读 ·
0 评论