Databases: MySQL stored procedures
Cosmin Cristea (contact me)
This class emulates stored procedures for MySQL databases used (MySQL) client side files to define the SQL code of the procedures.
It executes simple queries defined within a named block, known as "stored procedure".
The query syntax within a stored procedure is compliant with standard SELECT, INSERT, DELETE and UPDATE MySQL queries, but it does not accept sub-select queries like "INSERT ... SELECT".
Every stored procedure can have parameters that must be initialized before the execution.
Here is the of provided functionality:
- Loading and saving stored procedures on disk files.
- Procedure execution
- Dumping in HTML format the code of loaded procedures
- All the methods not implemented have a proprietary license
| Utility
| Consistency
| Docs
| Examples
| Tests
| Videos
| Overall
| Rank
|
| Good (85.0%)
| Good (80.0%)
| -
| Good (85.0%)
| -
| -
| Not sure (59.0%)
| 722 |
Click here for detailed information about this class on phpclasses.org