/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

0 vote136 views1 answer
Sql query contains multiple ids
SQL
0 vote124 views1 answer
Date diff sql
SQL
0 vote136 views1 answer
Change date in pivot table to month in sql server
SQL
3 votes140 views3 answers
Stop mysql ubuntu
SQL
0 vote158 views1 answer
Cannot insert duplicate key in object 'dbo.Instructor'. The duplicate key value is (2).
SQL
0 vote146 views1 answer
HOW to select specific table data from an mysql databse server:
SQL
1 vote130 views1 answer
Expression number 1 of select list is not in group by clause
SQL
2 votes91 views1 answer
Sql float to int
SQL
20 votes146 views3 answers
How to open postgresql in mac
SQL
0 vote154 views1 answer
How to check event scheduler status mysql
SQL