/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 vote197 views1 answer
Install package for sqlserver in asp.net core
SQL
1 vote180 views1 answer
Drush sql-dump
SQL
6 votes234 views2 answers
What is non relational database
SQL
1 vote233 views1 answer
Set statiscis on in sql server
SQL
0 vote184 views1 answer
Drop a field in psql django
SQL
3 votes235 views1 answer
How to uninstall microsoft sql server
SQL
2 votes223 views1 answer
Sql update \
SQL
0 vote181 views1 answer
Database xml sql
SQL
4 votes201 views2 answers
REST API
SQL
1 vote189 views1 answer
Mysql history command
SQL