查询父路径mysql
查询id为103的父路径如下,记录下,哈哈。。。。。
SELECT
GROUP_CONCAT( parent_id ) pid
FROM
(
SELECT
@a AS _id,
( SELECT @a := parent_id FROM sys_dept WHERE dept_id = _id ) AS parent_id
FROM
( SELECT @a := 103 ) vars,
sys_dept h
WHERE
@a <> 0
ORDER BY
parent_id ASC
) a
posted on 2024-03-01 21:12 zyp_java_net 阅读(14) 评论(0) 编辑 收藏 举报