What are the features of Stored Procedures in MYSQL?
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 |
Why do we need mysql?
How do I create a stored procedure in mysql?
How can you plan the logshipping before processing?
What are the other commands to know the structure of table using MySQL commands except explain command?
What is ddl, dml, and dcl?
How do you rename a procedure in mysql?
What is mvcc in mysql?
What is difference between function and procedure in mysql?
What is difference between microsoft sql and mysql?
What's the latest version of mysql?
What's new in mysql 8?
What is data type for image in mysql?