常用于子父级递归查询
WITH RECURSIVE _parent AS
(
SELECT t.* FROM `表1` t WHERE t.id='参数'
UNION ALL
SELECT t.* FROM _parent,`表1` t WHERE t.id=_parent.pid
)
SELECT * FROM _parent;
ps:
楼主使用mysql版本8.0
WITH RECURSIVE 将查询结果带入下次查询,进行递归,查询全路径
常用于子父级递归查询
WITH RECURSIVE _parent AS
(
SELECT t.* FROM `表1` t WHERE t.id='参数'
UNION ALL
SELECT t.* FROM _parent,`表1` t WHERE t.id=_parent.pid
)
SELECT * FROM _parent;
ps:
楼主使用mysql版本8.0
WITH RECURSIVE 将查询结果带入下次查询,进行递归,查询全路径