WITH RECURSIVE tmp0 AS (
SELECT
a.*
FROM
table1 a
WHERE
a.id = #{id}
UNION
SELECT
t1.*
FROM
table1 t1,
tmp0 t0
WHERE
1 = 1
AND t1.parent_id = t0.id
) SELECT
a.field1,
a.field2
FROM
tmp0 a
SQL递归--MySQL
最新推荐文章于 2024-05-27 22:25:23 发布