/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 vote185 views1 answer
Postgres foreign key multiple columns
SQL
0 vote135 views1 answer
Where in clause tsql
SQL
0 vote139 views2 answers
Sqlite unique
SQL
9 votes146 views6 answers
Sql add column with default value
SQL
0 vote166 views1 answer
Mysql dump with table query
SQL
15 votes147 views4 answers
Create table if not exists sql
SQL
8 votes153 views4 answers
How to calculate the age from date of birth in python
SQL
-1 vote132 views1 answer
Add column alter table default value
SQL
0 vote143 views1 answer
Mysql drop multiple tables at once
SQL
4 votes147 views1 answer
Wilayah indonesia database
SQL