Many people seem to ask this question periodically but I wanted the most
recent answer...
What's the current state of having support for CONNECT BY in MySQL? I'm
using MySQL 5.0.45 on CentOS 5.2 and noticed in the documentation that I
can't write my own recursive functions:
"Stored functions cannot be recursive."
http://dev.mysql.com/doc/refman/5.1/en/stored-routines-syntax.html
... so I guess I can't build my own recursive tree-traversing stored
procedures.
Is there support in MySQL 5.x, or MySQL 6.x for doing heirarchical
queries? Does MySQL now ... or will it later ... support CONNECT BY
syntax? Help would be appreciated.
-- Dante
----------
D. Dante Lorenso
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]