File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and the fly likes connect by prior clause in MySql Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Java 8 in Action this week in the Java 8 forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "connect by prior clause in MySql" Watch "connect by prior clause in MySql" New topic

connect by prior clause in MySql

krishnamoorthy kitcha
Ranch Hand

Joined: Feb 04, 2006
Posts: 96
Hi All,

In the oracle we had the option to populate the records in tree structure manner using the connect by prior clause , Is it possible to achieve the same using the MySql 6.0.6 or else we will define only the stored procedures or will MySql have any reserved functions.

Example :

RootA - SubRootA - SubRootAA
- SubRootB - SubRootBB
- SubRootC - SubRootCC . It is going dynamic.
Please respond as soon as possible.

Sorry for my ignorance.
Campbell Ritchie

Joined: Oct 13, 2005
Posts: 36555
Don't know. Have you tried the MySQL handbook?
subject: connect by prior clause in MySql
Similar Threads
servlets with flash mx 2004
query nested data ( interview question)
JTable question
Using Red5 with Adobe Flex3
CONNECT BY PRIOR clause (Oracle) with Hibernate