/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 vote267 views1 answer
Postgresql last element of array
SQL
0 vote309 views1 answer
Alling a function from PL/SQL in a select statement in ORACLE
SQL
0 vote222 views1 answer
Ms sql print more than 1 variable
SQL
2 votes267 views1 answer
Merge two columns in sql oracle
SQL
5 votes267 views1 answer
Ignore duplicate rows in sqlite
SQL
0 vote259 views1 answer
Install package for sqlserver in asp.net core
SQL
0 vote284 views1 answer
Mariadb current date plus 1 day
SQL
-1 vote297 views3 answers
Unknown collation: 'utf8mb4_0900_ai_ci'
SQL
3 votes300 views1 answer
Start mysql server linux terminal
SQL
0 vote277 views1 answer
Ms sql database data size
SQL