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.

http://www.onlamp.com/pub/a/onlamp/2004/08/05/hierarchical_sql.html

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.

Regards,

Josh

Josh Chamas
Director, Professional Services
MySQL Inc., www.mysql.com
Get More with MySQL! http://www.mysql.com/consulting

Options: ReplyQuote


Subject
Views
Written By
Posted
4299
November 23, 2004 06:49PM
Re: hierarchique
3087
November 23, 2004 08:19PM
2131
November 24, 2004 02:22PM
2080
November 24, 2004 03:51PM
2370
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.