MySQL Forums
Forum List  »  Oracle

Re: hierarchique
Posted by: Josh Chamas
Date: November 23, 2004 08:19PM

lionel chauvier wrote:
> I would like to know to translate this requete
> oracle into mysql.
> Without the clause "start with" and "connect by".

MySQL does not have this Oracle specific feature.

I would recommend this article to for ways of thinking about
a hierarchy structure without recursive SQL support.

Also consider that if you really need database side recursion
today, you might take a look at our 5.0.x alpha release which
has stored procedures implemented already and with which you
could implement your own recursive algorithm in the database.

> PS: For when the migration of this clause?

I am not currently aware of any plan to implement this proprietary SQL syntax.



Josh Chamas
Director, Professional Services
MySQL Inc.,
Get More with MySQL!

Options: ReplyQuote

Written By
November 23, 2004 06:49PM
Re: hierarchique
November 23, 2004 08:19PM
November 24, 2004 02:22PM
November 24, 2004 03:51PM
November 25, 2004 11:59AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.