Re: call SP with dynamic SQL

[Desmond Coertzen]

Recursion would have been a nice feature in MySQL. I have a hierarchy defined in one table where one record will have an FK to point to its parent in the same table. To iterate through the hierarchy, recursion would have been an elegant solution, the same way you would use recursion in application programming to iterate over a hierarchy of a file system - iterate as in drill into directories and subdirectories.