MySQL Forums
Forum List  »  Stored Procedures

Advanced Search
New Topic

Re: connect by prior
Posted by: Roland Bouman
Date: August 05, 2005 05:45AM

Nope, no connect by. But you can work around it.

Check out this thread:

http://forums.mysql.com/read.php?10,32818,32818#msg-32818

Cut short, you can either reorganise your table so that it does not depend on recursion anymore. You should definitely check that out:

http://www.vbmysql.com/articles/managing-hierarchical-data-in-mysql.html

(thanks erin for the link)

Or you can rewrite your procedure to process the hierarchy by iteration, not recursion.


As for recursion, latest I heard is here:

http://forums.mysql.com/read.php?98,33289,33516#msg-33516

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
connect by prior
31833
lic
August 05, 2005 01:07AM
Re: connect by prior
25670
Roland Bouman
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.