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 heap table?
How to delete the repeated records from a table?
What is maximum table size in mysql?
What is the difference between float and double?
What is mysql database extension?
What is the maximum size of table in mysql?
How many TRIGGERS are allowed in MySql table?
How do I restore a mysql database dump file in linux?
What is MySQL Stored Procedure?
How do I disconnect mysql workbench?
What is mysql database server?
How to get data from mysql in php?
Oracle (3253)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)