MySQL Forums
Forum List  »  Oracle

Advanced Search
New Topic

Re: Does MySQL 5.0 support hierarchial queries?
Posted by: Peter Gulutzan
Date: October 23, 2006 02:12PM

MySQL does not support the Oracle-specific CONNECT BY clause.

Sometimes hierarchical queries are possible via stored procedures.
For an example (though it may be slightly out of date now):
http://dev.mysql.com/tech-resources/articles/mysql-storedprocedures.html

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


Subject
Views
Written By
Posted
Support for hierarchical queries?
11522
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?
4306
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.