Interested to Buy Any Domain ? << Click Here >> for more details...
What are the features of Stored Procedures in MYSQL?
- 1 Answers
- 1320 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 is the difference between MyISAM Static and MyISAM Dynamic?
Can we store files in mysql?
How to get current MySQL version?
How to delete a table.
What is full text indexing in mysql?
How to see table's field formats or description of table .
What is mysql gpl?
What are triggers mysql?
What does innodb stand for?
How many columns can a table have?
Is mysql a backend?
What language is used in mysql?
What is the use of mysqli_connect in php?
What is mysql protocol?
What is a deterministic function?
