MySQL Forums
Forum List  »  Knowledge Base

Re: Table Walk using parent/child foreign keys
Posted by: Paul Svirin
Date: October 21, 2009 11:42AM

Here is a document discussing the subject: http://dev.mysql.com/tech-resources/articles/hierarchical-data.html

But it seems that it is based on the suggestion that maximum depth is known because the joins number depends on it. If your max depth is undefined - then it seems that the only way is to do loops in JSP. :(

Hope that helps.

-----------------
StarWind Software developer ( http://www.starwindsoftware.com )

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Table Walk using parent/child foreign keys
1899
October 21, 2009 11:42AM


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.