帮助编写嵌套集的SQL查询

我正在使用嵌套集将数据库存储在数据库中.表的字段是id,lft,rgt和name.

给定一个节点ID,我需要找到它们自己的叶子节点的所有直接子节点(不是孙子节点).

解决方法

这是如何找到节点的直接子节点：

SELECT node.name,(COUNT(parent.name) - (sub_tree.depth + 1)) AS depth
FROM nested_category AS node,nested_category AS parent,nested_category AS sub_parent,(
        SELECT node.name,(COUNT(parent.name) - 1) AS depth
        FROM nested_category AS node,nested_category AS parent
        WHERE node.lft BETWEEN parent.lft AND parent.rgt
        AND node.name = '**[[MY NODE]]**'
        GROUP BY node.name
        ORDER BY node.lft
    )AS sub_tree
WHERE node.lft BETWEEN parent.lft AND parent.rgt
    AND node.lft BETWEEN sub_parent.lft AND sub_parent.rgt
    AND sub_parent.name = sub_tree.name
GROUP BY node.name
HAVING depth = 1
ORDER BY node.lft;

然后将它与叶子节点的rgt等于lft 1这一事实相结合,然后进行设置.原谅双关语.

（编辑：衡阳站长网）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!