初始数据是这样的,sql递归代码:
/*从根节点向下递归*/
WITH RECURSIVE _children AS
(
SELECT t.* FROM `test` t WHERE t.pid=0
UNION ALL
SELECT t.* FROM _children,`test` t WHERE t.pid=_children.id
)
SELECT * FROM _children;
执行以后是这样的;
今天在写树结构时用到了sql递归,记录一下mysql向下递归写法,还有个向上递归的暂时找不到了,欢迎补充~