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