/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

2 votes96 views5 answers
Alter table primary key postgresql
SQL
0 vote139 views1 answer
SQL SERVER SELECT BETWEEN DATETIME
SQL
0 vote137 views1 answer
Get role postgres
SQL
0 vote201 views1 answer
Sql to search who modified
SQL
0 vote142 views1 answer
Postgresql auto increment not working
SQL
0 vote134 views1 answer
What is SQL data store?
SQL
0 vote139 views1 answer
Postgresql delete limit
SQL
4 votes131 views2 answers
Mysql delete user if exists
SQL
0 vote167 views1 answer
Linux upload database to mysql
SQL
1 vote146 views2 answers
Restart identity cascade
SQL