/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 vote196 views3 answers
How to truncate table with foreign key constraint
SQL
0 vote187 views1 answer
Oracle archivemode
SQL
0 vote190 views1 answer
Postgresql extract hour and minutes from timestamp
SQL
0 vote188 views1 answer
Sql change primary key to composite key
SQL
5 votes225 views2 answers
Oracle show procedures
SQL
0 vote184 views2 answers
Sql server Insert Into table
SQL
5 votes202 views2 answers
Oracle list columns
SQL
0 vote194 views1 answer
Sql doesn't contain
SQL
0 vote194 views1 answer
How to locate pg_hba.conf file
SQL
0 vote189 views1 answer
Plpgsql raise notice
SQL