์ค๋ผํด ๊ณ์ธตํ์ฟผ๋ฆฌ mysql(maria db)๋ก ๋ณ๊ฒฝ
select id, name, parentfrom (select * from RecursionTest order by parent, id) products_sorted, (select @pv := '3') initialisationwhere find_in_set(parent, @pv) > 0and @pv := concat(@pv, ',', id) ์ถ์ฒ: http://bulkywebdeveloper.tistory.com/109 [๊ฑด๊ฐํ ์ฝ๋ฉ] with recursive cte (id, name, parent) as( select id, name, parent from recursiontest where parent = 3 union all select r.id, r.name, r.parent from re..
๋๋ณด๊ธฐ