mysql如何实现oracle start with下面是oracle中的sql语句求mysql写法

Question

select e.org_id organid,
e.parentid ownerorganid,
e.org_code organcode,
e.org_name organname,
e.org_type organtype
from product_organisation e
where e.org_type='1'
start with e.org_id =
(select our.org_id from PRODUCT_USER_ORG_RE our
where our.user_id='USR160304000012')
connect by prior e.parentid=e.org_id

Answer 1

用mysql的话就比较复杂了，
http://blog.csdn.net/nimeijian/article/details/50425715