Re: How to concatenate SQL within a stored procedure?

[Peter Brawley]

MySQL sprocs offer no additional security or significant performance. Like all stored routines they offer encapsulation & modularisation, but at the cost of requiring use of an awkward, crippled language with no debugger. Their implementation makes them difficult to use in shared hosting environments, and that's passing strange since that's where there are so many MySQL users.

Some database computation (eg edge list tree models) require stored routines. They can be used to automate some db admin tasks. But before the general rule we all learned regarding the advantages of sprocs can be applied to MySQL, the MySQL implementation of them will need to be beefed up considerably.