要解决一个DB移植的问题从oracle到mysql
请教高手oracle中start with...connect by prior怎么改成mysql的递归,在mysql数据库下运行
select
tbl1.org_id
, tbl2.org_cd
, tbl2.multi_org_cd
, level as menu_lvl
, rownum as prt_seq
from rsm_org_rel tbl1,
rsm_org tbl2
where tbl1.org_id = tbl2.org_id
and tbl2.del_yn = '0'
and to_char(sysdate, 'yyyymmdd') >= tbl2.aply_sta_dt
and to_char(sysdate, 'yyyymmdd') <= tbl2.aply_end_dt
start with tbl1.org_id(+) = '1000000003'
connect by prior tbl1.org_id = tbl1.rel_org_id
请教高手oracle中start with...connect by prior怎么改成mysql的递归,在mysql数据库下运行
select
tbl1.org_id
, tbl2.org_cd
, tbl2.multi_org_cd
, level as menu_lvl
, rownum as prt_seq
from rsm_org_rel tbl1,
rsm_org tbl2
where tbl1.org_id = tbl2.org_id
and tbl2.del_yn = '0'
and to_char(sysdate, 'yyyymmdd') >= tbl2.aply_sta_dt
and to_char(sysdate, 'yyyymmdd') <= tbl2.aply_end_dt
start with tbl1.org_id(+) = '1000000003'
connect by prior tbl1.org_id = tbl1.rel_org_id
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货