/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

2 votes121 views2 answers
Mysql bidirectional composite primary key
SQL
6 votes115 views2 answers
How to get yesterday date in mysql
SQL
1 vote124 views1 answer
How to select random rows from a table
SQL
0 vote117 views1 answer
Query to generate query to drop primary keys or foreign key in ms sql server
SQL
0 vote123 views1 answer
T sql check active deadlock
SQL
2 votes125 views1 answer
Sql missing records from another table
SQL
0 vote120 views1 answer
Mysql select inside sum
SQL
0 vote111 views1 answer
Sql insert tuple
SQL
0 vote165 views1 answer
Ora 00001 error catch plsql
SQL
2 votes111 views1 answer
Date_format for time sql
SQL