mysql根据当前节点查询所有的父节点
SELECT T2.id, T2.name FROM ( SELECT @r AS _id, (SELECT @r := parent_id FROM t_department WHERE id = _id) AS parent_id, @l := @l + 1 AS lvl FROM (SELECT @r := #{id}, @l := 0) vars, t_smart_cr..
原创
2021-04-14 17:35:41 ·
359 阅读 ·
0 评论