aspose file tools
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


Win a copy of Groovy Fundamentals video training course this week in the Groovy forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "connect by prior clause in MySql" Watch "connect by prior clause in MySql" New topic
Author

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
Sheriff

Joined: Oct 13, 2005
Posts: 42657
    
  31
Don't know. Have you tried the MySQL handbook?
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: connect by prior clause in MySql