MySQL Forums
Forum List  »  Oracle

Advanced Search
New Topic

Re: Support for hierarchical queries?
Posted by: Josh Chamas
Date: September 26, 2004 07:46AM


MySQL does not yet support CONNECT BY PRIOR, however it is planned for a future release.

For now, recursive queries need to be implemented in a programming language. There
is stored procedure support in MySQL 5.0, which will be released stable in Q1 2005,
so you could rewrite the recursion there and still have it on the database side.

Regards,

Josh

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

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
Support for hierarchical queries?
11523
Nathan Christiansen
August 26, 2004 03:30PM
Re: Support for hierarchical queries?
6119
Josh Chamas
September 26, 2004 07:46AM
Re: Support for hierarchical queries?
3969
Nathalie Doremieux
May 12, 2005 05:24PM
Re: Support for hierarchical queries?
3820
MuraliDharan V
August 02, 2006 04:27AM
mysql Support hierarchical queries--URGENT?
4455
rama krishna
February 02, 2005 12:44AM
Re: mysql Support hierarchical queries--URGENT?
5798
Josh Chamas
February 02, 2005 12:53AM
Does MySQL 5.0 support hierarchial queries?
4032
Mohan Rao
October 18, 2006 12:54AM
Re: Does MySQL 5.0 support hierarchial queries?
4307
Peter Gulutzan
October 23, 2006 02:12PM


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.