mysql connect by 实现_mysql实现类似oracle的connect by功能

1.生成测试表与数据:

create table mytest

(

id int primary key,

nodename varchar(20),

pid int

);

insert into mytest (id,nodename,pid)values(  1 ,'A', 0);

insert into mytest (id,nodename,pid)values(  2 ,'B', 1);

insert into mytest (id,nodename,pid)values(  3 ,'C', 1);

insert into mytest (id,nodename,pid)values(  4 ,'D', 2);

insert into mytest (id,nodename,pid)values(  5 ,'E', 2);

insert into mytest (id,nodename,pid)values(  6 ,'F', 3);

insert into mytest (id,nodename,pid)values(  7 ,'G', 6);

insert into mytest (id,nodename,pid)values(  8 ,'H', 0);

insert into mytest (id,nodename,pid)values(  9 ,'I', 8);

insert into mytest (id,nodename,pid)values( 10 ,'J', 8);

insert into mytest (id,nodename,pid)values( 11 ,'K', 8);

i