/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 vote360 views1 answer
Default order by in mysql
SQL
0 vote370 views2 answers
Mysql missin expression near on
SQL
0 vote325 views1 answer
Original Query
SQL
3 votes304 views1 answer
System.debug apex
SQL
3 votes347 views2 answers
Sqlite print all column names
SQL
0 vote338 views1 answer
Mysql utc timestamp
SQL
0 vote325 views1 answer
Mysql installer no packages found
SQL
0 vote325 views1 answer
Install package for sqlserver in asp.net core
SQL
1 vote335 views2 answers
Datetrunc hour snowflake
SQL
0 vote366 views1 answer
Select true if exists on another table or false sqlserver
SQL