/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 vote332 views1 answer
Window function mysql
SQL
0 vote333 views1 answer
Mysql loop through databases and execute query
SQL
15 votes339 views4 answers
Export mysql db using command line
SQL
1 vote336 views1 answer
How to remove identity from a column in sql server
SQL
0 vote328 views1 answer
How to input data as id in database sql c#
SQL
0 vote314 views2 answers
How to start postgresql laravel
SQL
9 votes340 views5 answers
Laravel to sql
SQL
23 votes320 views4 answers
How to uninstall postgresql in ubuntu
SQL
2 votes391 views1 answer
Tcl in sql
SQL
1 vote320 views2 answers
Mysql extract month
SQL