What are the features of Stored Procedures in MYSQL?
Answer Posted / hrindows@gmail.com
Stored Procedure increases the performance of the applications. Once stored procedures are created, they are compiled and stored in the database.
Stored procedure reduces the traffic between application and database server. Because the application has to send only the stored procedure's name and parameters instead of sending multiple SQL statements.
Stored procedures are reusable and transparent to any applications.
A procedure is always secure. The database administrator can grant permissions to applications that access stored procedures in the database without giving any permission on the database tables.
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is the current root password of mysql?
What is 1nf 2nf 3nf?
How to shut down the server with 'mysqladmin'?
What's the difference between mysql and sql server?
What is the usage of regular expressions in mysql?
How we can get distinct columns values in mysql?
Is postgresql better than mysql?
How is mysql database stored?
How do I clear a mysql database?
Is mysql same as sql?
How to insert html code into mysql database using php?
How to create a new view in mysql?
How do I edit a database in mysql workbench?
What is sql vs mysql?
How do I change global variables in mysql?