MySQL Forums
Forum List  »  Knowledge Base

Advanced Search
New Topic

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 )

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


Subject
Views
Written By
Posted
Table Walk using parent/child foreign keys
3341
Jack Baker
October 12, 2009 10:15AM
Re: Table Walk using parent/child foreign keys
1928
Paul Svirin
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.