MySQL Forums
Forum List  »  Stored Procedures

connect by prior
Posted by: lic
Date: August 05, 2005 01:07AM

Hi,

I’m looking for some methods to handle a tree like structure data in MySQL 5.

I have read that in version 5 oracle like CONNECT BY PRIOR clause will be implemented.

I have tried to write a recursive stored procedure to simulate CONNECT BY.... But, unfortunately I have noticed that recursive call is no more allowed.

My questions are:
- at this moment is something like Oracle CONNECT BY PROIR clause in MySQL?
- If not, have you any idea where this feature will be included?
- About recursivity, when will be re-included?

Thanks

Options: ReplyQuote


Subject
Views
Written By
Posted
connect by prior
31752
lic
August 05, 2005 01:07AM
25652
August 05, 2005 05:45AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.