File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases 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
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
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: 46375
Don't know. Have you tried the MySQL handbook?
I agree. Here's the link:
subject: connect by prior clause in MySql
It's not a secret anymore!