/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

1 vote183 views2 answers
Sql left characters
SQL
10 votes176 views2 answers
Mysql alter add foreign key
SQL
14 votes191 views3 answers
Oracle sql limit results
SQL
0 vote176 views1 answer
Sql make sure every user is unqiuew
SQL
0 vote283 views1 answer
Oracle sql all days except weekends
SQL
0 vote173 views4 answers
Mysql select bottom 10 rows
SQL
0 vote183 views1 answer
How to declare variable date in mysql
SQL
2 votes185 views3 answers
How to check current user in mySQL
SQL
0 vote194 views1 answer
How to set all the time serveroutput on in oracle sql developer
SQL
1 vote167 views1 answer
Deleting database in sql
SQL