oracle 里 语句是create or replace view v_net as
select net_ip ,lpad('|---',8*(level-1),' ')||net_name net_name,net_num,net_state,t.id,t.net_num2,t.net_num3,t.parent_id,t.net_time
from v_net_set t start with parent_id is null connect by prior net_ip = parent_id;
表结构为
想在mysql里查询 得到结果为