/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 vote161 views1 answer
Sqlalchemy case insensitive like
SQL
0 vote134 views1 answer
Oracle sql generate list of days
SQL
0 vote150 views2 answers
Dbms transaction tutorialspoint
SQL
0 vote128 views1 answer
In mysql workbench contnent not feching
SQL
1 vote131 views1 answer
Order by oracle
SQL
0 vote143 views1 answer
Illuminate/Database/QueryException with message 'SQLSTATE[42S02]
SQL
0 vote139 views1 answer
Pl/ sql change currency
SQL
0 vote141 views1 answer
Createdb with postgresql on ubuntu
SQL
4 votes137 views2 answers
Mysql delete user if exists
SQL
5 votes129 views1 answer
List foreign key oracle
SQL