/SQL/Mysql 5.6 hierarchical recursive query

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))

Similar codes

34 votes295 views6 answers
Sql change data type
SQL
104 votes505 views2 answers
Like in mysql
SQL
8 votes291 views3 answers
Mysql alter table add index
SQL
2 votes265 views1 answer
Latest record in sql
SQL
0 vote314 views1 answer
Sql check if column exists
SQL
1 vote292 views1 answer
Oracle sql assign unique number to each grouping
SQL
1 vote334 views2 answers
Intersect sql
SQL
0 vote313 views1 answer
Where to find pg_hba.conf in ubuntu
SQL
0 vote310 views1 answer
Plpgsql raise notice
SQL
1 vote279 views1 answer
Sequence item 6 expected str instance bytes found mysql workbench
SQL