>
> The real problem is the lack of recursion in MySQL, and this issue is
> independent of stored procedures. It would be nice if it was possible to
> write a query, loop around it, and store intermediate results in a
> temporary table within the database.
>
> For the record, does anyone know if control structures such as this are
> being considered for future releases?
They are being considered:
"we aim toward full compliance with SQL-92/SQL-99"
http://www.mysql.com/doc/en/TODO_unplanned.html
That includes WITH ... RECURSIVE support. Only long term is after
mid-term, near-term, 5.1, 5, and 4.1, so don't hold your breath.
Jochem
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
