Usage of HIERARCHICAL Queries in MySQL

sushma007 · #1 (**permalink**) 12-03-07, 02:06

Hi All ,

Will MySQL supports START WITH ..CONNECT BY Clause. I have a SELECT Statement(With Start With .. Connect By Clause) that will returns the Hierarchical data of a particular Table .

Is there any way to Query MySQL to get the same out put .

Oracle SQL:

Quote:

Select parent1,child from hierrarchy start with parent1=1 connect by parent1=child

I am in need of getting the MySQL Equivalent of the above Oracle query .

Thanks ,
Sushma

r937 · #2 (**permalink**) 12-03-07, 03:28

Quote:

Originally Posted by sushma007

Is there any way to Query MySQL to get the same out put .

no, there isn't

johndz · #3 (**permalink**) 12-04-07, 16:17

You may be able to write a set of stored procedures to mimic "connect by" . See page 60 of this document:

http://dev.mysql.com/tech-resources/...procedures.pdf

Internet Services

Web Development

Digital Marketing

Consumer Tech