/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 vote142 views1 answer
Mysql replication change database name
SQL
0 vote210 views1 answer
Mariadb date equals to current_date plus days
SQL
0 vote135 views1 answer
. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (.Net SqlClient Data Provider)
SQL
0 vote157 views1 answer
Soql last week
SQL
1 vote200 views1 answer
Oracle see column type
SQL
0 vote134 views1 answer
Postgresql alter column nullable
SQL
0 vote147 views1 answer
Sql select where more than one record exists
SQL
1 vote139 views1 answer
Sql bitwise operators
SQL
11 votes144 views1 answer
Oracle view source
SQL
6 votes197 views3 answers
POSTGRES INSERT INTO TABLE VALUE FROM OTHER TABLE
SQL