/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

3 votes322 views2 answers
Synonym oracle
SQL
0 vote296 views1 answer
FILENAME /usr/bin/mysql does not exists. Make sure correct path is set in /etc/dump admin/settings.conf.
SQL
0 vote294 views1 answer
Get who is hired in month in sql
SQL
0 vote260 views1 answer
Sql random decimal
SQL
8 votes291 views2 answers
Select table column name in sql
SQL
3 votes279 views2 answers
Pl sql escape '
SQL
0 vote298 views1 answer
Can we rollback in sql
SQL
0 vote284 views1 answer
Count characters of string mysql
SQL
1 vote296 views1 answer
Mysql select all and rename one
SQL
4 votes287 views1 answer
Is there any command to change postgres password
SQL