MySQL Forums
Forum List  »  Stored Procedures

Re: Path of entry in hierarchical table
Posted by: Glenn Thomas Hvidsten
Date: May 12, 2012 04:23AM

This all seems good, but my table is not an "edge-adjacency list" and I don't want to go through the trouble of rewriting my code.
I know this is possible with the kind of table I currently have. I probably have to use a LOOP-statement, but I'm just not fluent enough in MySQL to make this work.

Other suggestions are very welcome.

Options: ReplyQuote




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.