Mysql获取父子节点

最新推荐文章于 2021-12-02 17:00:37 发布

原创最新推荐文章于 2021-12-02 17:00:37 发布 · 486 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#mysql

Mysql 专栏收录该内容

2 篇文章

订阅专栏

Mysql 获取父级，子级数据

获取所以父ID
SELECT ID.level, DATA.* FROM( SELECT @id AS _id, ( SELECT @id := parentid FROM configclass WHERE id = @id ) AS _pid, @l := @l+1 AS LEVEL FROM configclass, (SELECT @id := 104, @l := 0 ) b WHERE @id > 0 ) ID, configclass DATA WHERE ID._id = DATA.id ORDER BY LEVEL;

获取所有子ID
SELECT LEVEL, DATA.* FROM( SELECT @ids AS _ids, ( SELECT @ids := GROUP_CONCAT(id) FROM configclass WHERE FIND_IN_SET(parentid, @ids) ) AS cids, @l := @l+1 AS LEVEL FROM configclass, (SELECT @ids :='88', @l := 0 ) b WHERE @ids IS NOT NULL ) id, configclass DATA WHERE FIND_IN_SET(DATA.id, _ids) ORDER BY LEVEL, id