SELECT T2.id,T2.name
FROM (
SELECT
@r AS _id,
(SELECT @r := parent FROM permission WHERE id = _id) AS pid,
@l := @l + 1 AS lvl
FROM
(SELECT @r := 8, @l := 0) vars,
permission h
WHERE @r <> 0) T1
JOIN permission T2
ON T1._id = T2.idORDER BY T1.lvl DESC
求高手解释下
@r @1 :=@1+1 这都什么意思
FROM
(SELECT @r := 8, @l := 0) vars ?????????????
FROM (
SELECT
@r AS _id,
(SELECT @r := parent FROM permission WHERE id = _id) AS pid,
@l := @l + 1 AS lvl
FROM
(SELECT @r := 8, @l := 0) vars,
permission h
WHERE @r <> 0) T1
JOIN permission T2
ON T1._id = T2.idORDER BY T1.lvl DESC
求高手解释下
@r @1 :=@1+1 这都什么意思
FROM
(SELECT @r := 8, @l := 0) vars ?????????????
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货