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 EJB 3 in Action this week in the EJB and other Java EE Technologies 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: 36478
Don't know. Have you tried the MySQL handbook?
Consider Paul's rocket mass heater.
subject: connect by prior clause in MySql
Similar Threads
servlets with flash mx 2004
Using Red5 with Adobe Flex3
query nested data ( interview question)
CONNECT BY PRIOR clause (Oracle) with Hibernate
JTable question