数据库向下递归

1、oracle向下递归

-- 向下递归
SELECT *
FROM erc_prop_cate_info
START WITH ID =2
CONNECT BY PRIOR id = PARENT_ID
order by ID;

2、mysql向下递归

# 向下递归
WITH RECURSIVE sub_tree AS (
    SELECT id,parent_id,name
    FROM mat_categ WHERE id = 1370
    UNION ALL
    SELECT o.id,o.parent_id,o.name
    FROM mat_categ o INNER JOIN sub_tree st ON o.parent_id = st.id
)
SELECT id FROM sub_tree;