/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 vote202 views2 answers
Alter table add multiple columns mysql
SQL
8 votes234 views1 answer
My sql version
SQL
1 vote201 views3 answers
What is union in sql
SQL
1 vote292 views2 answers
Job for mysql.service failed because the control process exited with error code. see "systemctl status mysql.service" and "journalctl -xe" for details.
SQL
2 votes204 views1 answer
Mysql Incorrect column specifier for column
SQL
2 votes165 views4 answers
Mysql change database character set to utf8mb4
SQL
18 votes200 views3 answers
Mysql number format
SQL
0 vote213 views1 answer
Get the next column of a table in mysql
SQL
0 vote209 views1 answer
How to use group_concat in sql server
SQL
0 vote218 views1 answer
Sql date time query find
SQL