jQuery in Action, 3rd edition
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 OCA Java SE 8 Programmer I Study Guide this week in the OCAJP 8 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: 44530
    
  34
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
 
It's not a secret anymore!