Interested to Buy Any Domain ? << Click Here >> for more details...
What are the features of Stored Procedures in MYSQL?
- 1 Answers
- 1407 Views
- I also Faced
- E-Mail Answers
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 are the steps required to view your mysql database?
Can we write pl sql mysql?
What are aggregate functions in mysql?
How do I stop a mysql command?
How do I show all mysql databases?
What is a deterministic function?
Which storage engine is best in mysql?
How to store binary data in mysql?
What is heap table in mysql?
Is mysql port 3306 tcp or udp?
What is the usage of ENUMs in MySQL?
How to return query output in html format?
Why MySQL is used?
How can you change the name of any existing table by using the sql statement?
How to see the create table statement of an existing table?
