What are the features of Stored Procedures in MYSQL?



What are the features of Stored Procedures in MYSQL?..

Answer / 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

More MySQL Interview Questions

What is database migration in mysql?

0 Answers  


What is pragma exception?

0 Answers  


suppose server is running Suddenly down . what can you do? but i want do not down the server?

3 Answers  


How can we find out which auto increment was assigned on Last insert?

0 Answers  


How do I change directories in mysql?

0 Answers  


What is the storage engine used for MySQL?

1 Answers  


What is the default port for MySQL Server?

0 Answers  


How do I set user privileges in mysql?

0 Answers  


What is use of mysql?

0 Answers  


How do you create a schema?

0 Answers  


What is unique key in mysql?

0 Answers  


In how many ways we can retrieve the data in the result set of MySQL using PHP? What is the difference between mysql_fetch_object and mysql_fetch_array ?

0 Answers  


Categories