mysql 查询子父节点

最新推荐文章于 2024-06-04 17:57:46 发布

yuchunfanger

最新推荐文章于 2024-06-04 17:57:46 发布

阅读量875

点赞数 1

分类专栏： MYSQL 文章标签：哈希算法算法 mysql

本文链接：https://blog.csdn.net/yuchunfangxxx/article/details/121681408

版权

MYSQL 专栏收录该内容

11 篇文章 0 订阅

订阅专栏

查询所有子节点：

SELECT * FROM
			 (
			    SELECT * FROM blade_dept
			 ) T1,
			 (SELECT @PV := '1367646653837742082' ) T2
		WHERE ((FIND_IN_SET(parent_id,@PV) > 0
		AND @PV := CONCAT(@PV, ',', id)))

查询所有父节点，包含自己


SELECT T2.* FROM (
            SELECT
               @R AS _ID,
               (SELECT @R := parent_id FROM blade_dept WHERE id = _ID) AS PAR_ID,
               @L := @L + 1 AS LVL
            FROM
            (SELECT @R := '1453895863325241345', @L := 0) VARS,
            blade_dept H
            WHERE @R <> 0
        ) T1
        INNER JOIN blade_dept T2 ON T1._ID = T2.id
        ORDER BY T1.LVL DESC