![](https://img-blog.csdnimg.cn/20201014180756930.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
mysql
波波101
这个作者很懒,什么都没留下…
展开
-
MySQL查询某个子节点的顶级节点(根节点)
MySQL查询某个子节点的顶级节点(根节点)SELECT T2.* FROM ( SELECT @r AS _id, ( SELECT @r := parent_id FROM `look_project_process` WHERE id = _id ) AS 2v2, @l := @l + 1 AS lvl FROM ( SELECT @r := 'e718165baece49678359dd945371f93e', @l := 0 ) vars, look_proje原创 2022-04-09 14:12:47 · 3170 阅读 · 5 评论 -
mysql递归查询,根据子类查询所有父类
mysql递归查询,根据子类查询所有父类或者根据父类查询所有的子类1、根据子类查询父类1、根据子类查询父类SELECT T2.* FROM ( SELECT @r AS _id, ( SELECT @r := parent_id FROM sys_safety_partial WHERE id = _id ) AS parent_id, @l := @l + 1 AS lvl FROM ( SELECT @r := 'a55288a9b5eb15e1653339fee1bc7原创 2022-02-26 13:43:46 · 1178 阅读 · 0 评论