Re: How to concatenate SQL within a stored procedure?
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.
Subject
Views
Written By
Posted
10520
June 19, 2013 10:24PM
6067
June 19, 2013 11:49PM
1870
June 20, 2013 12:13PM
2044
June 20, 2013 03:35PM
1402
June 20, 2013 06:41PM
Re: How to concatenate SQL within a stored procedure?
1590
June 20, 2013 07:52PM
1539
June 20, 2013 08:06PM
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.