mysql查询父子级
上下级关系数据
查询父级数据
SELECT ab.pId
FROM
(
SELECT
@r AS _id,
(SELECT @r := pId FROM area WHERE id = _id) AS pId
FROM
(SELECT @r := '7')vars,area a
WHERE @r is not null
) ab
where pId is not null
查询id为7的父级结果
查询子级数据
SELECT
id
FROM
(
SELECT
@r AS _id
原创
2021-07-14 15:22:08 ·
1776 阅读 ·
1 评论