Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2007
    Posts
    64

    Thumbs down Unanswered: Usage of HIERARCHICAL Queries in MySQL

    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:

    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

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    Quote Originally Posted by sushma007
    Is there any way to Query MySQL to get the same out put .
    no, there isn't
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  3. #3
    Join Date
    Dec 2004
    Location
    Broomfield, Colorado
    Posts
    16

    mysql hierarchy

    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •