/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 vote208 views1 answer
Oracle avg
SQL
0 vote214 views1 answer
How to get table current identity value in sql server
SQL
5 votes211 views5 answers
Sqlite install python
SQL
0 vote202 views1 answer
Get enginge db mysql
SQL
4 votes210 views2 answers
Oracle unlock user
SQL
22 votes200 views2 answers
Mysql show all tables
SQL
0 vote230 views1 answer
How to pass list as parameter in SQL query
SQL
11 votes583 views4 answers
Reset identity column values in sql server
SQL
0 vote237 views1 answer
Prisma transaction
SQL
2 votes214 views1 answer
Oracle sql merge
SQL