mysql获取某个节点的所有子孙节点

最新推荐文章于 2024-07-30 02:09:59 发布

醉书生ꦿ℘゜এ

最新推荐文章于 2024-07-30 02:09:59 发布

阅读量453

点赞数 4

分类专栏： mysql 文章标签： mysql android 数据库

本文链接：https://blog.csdn.net/zslsh44/article/details/139355343

版权

mysql 专栏收录该内容

4 篇文章 0 订阅

订阅专栏

获取某个菜单的所有子孙节点同理

SELECT id,dept_name,parent_id
FROM
(SELECT id,parent_id,dept_name FROM sys_dept where parent_id > 0 ORDER BY parent_id, sort) a,
(SELECT @pid :=1) b
WHERE (FIND_IN_SET(parent_id,@pv)>0 And @pid := concat(@pid, ',', id))

获取所有父节点sql

此sql查询id=3的所有父节点sql

SELECT t2.id FROM ( SELECT @r AS _id, (SELECT @r := parent_id FROM dept WHERE id = _id) AS parent_id, @l := @l + 1 AS lvl FROM (SELECT @r := 3, @l := 0) vars, dept WHERE @r != 0) t1 JOIN dept t2 ON t1._id = t2.id ORDER BY t1.lvl DESC