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 |
What is difference between group by and order by clause?
What is mysql default port number?
what is the main difference between myisam and innodb
How does mysql store dates?
What is the data type for image?
How is mysql database stored?
How do I setup a mysql database?
What is mysql connector used for?
What is the purpose of using a heap table?
how to delete duplicate rows in sql server 2005?
How many concurrent queries can mysql handle?
What is blob and text in mysql?