/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 vote217 views2 answers
Mysql: command not found
SQL
3 votes233 views2 answers
Savepoint in sql
SQL
6 votes214 views2 answers
Can't connect to local mysql server through socket
SQL
2 votes248 views2 answers
Python escape string for sql
SQL
0 vote222 views1 answer
Unable to convert mysql date/time value to system.datetime
SQL
4 votes217 views3 answers
Rename table column postgresql
SQL
0 vote233 views1 answer
Mysql where don't have string
SQL
3 votes211 views1 answer
Sql set null
SQL
2 votes225 views1 answer
Query to check cpu utilization in oracle database
SQL
0 vote164 views1 answer
Oracle sql replace string in clob
SQL