Answers for "mysql 5.6 hierarchical recursive query"

SQL
0

mysql 5.6 hierarchical recursive query

select  id,
        name,
        parent_id 
from    (select * from products
         order by parent_id, id) products_sorted,
        (select @pv := '19') initialisation
where   find_in_set(parent_id, @pv)
and     length(@pv := concat(@pv, ',', id))
Posted by: Guest on March-11-2020

Code answers related to "mysql 5.6 hierarchical recursive query"

Code answers related to "SQL"

Browse Popular Code Answers by Language