/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

3 votes231 views2 answers
How to load files in mysql
SQL
13 votes235 views2 answers
Oracle select into and inner join
SQL
0 vote256 views1 answer
Mysql relationships between tables
SQL
2 votes214 views2 answers
Mysql all columns
SQL
0 vote226 views1 answer
Oracle exchange partition
SQL
1 vote214 views1 answer
How to get alternate records from a table in sql
SQL
0 vote248 views1 answer
Oracle drop type
SQL
1 vote235 views1 answer
How to see which columns are indexxed mysql
SQL
1 vote213 views1 answer
Limit offset order by mysql
SQL
0 vote218 views1 answer
Services.AddDbContext DataSource Sqlite
SQL