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 usage of "i-am-a-dummy" flag in mysql?
What are numeric data types?
How do I kill a mysql query?
What are the 5 r's of managing behaviors?
Which software is used for mysql?
How to delete a column and add a new column to database
How to show all records starting with the letters 'sonia' and the phone number '9876543210'
List some comparisons operators used in mysql?
How much does mysql cost?
Why do gaps in sequences occur?
How to use like conditions?
What is row level locking in mysql?
What is innodb mysql?
How do I restart mysql on windows?
What is striped backup