What are the features of Stored Procedures in MYSQL?
- 1 Answers
- 604 Views
- I also Faced
- E-Mail Answers
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 |
How do I truncate all tables in mysql?
How do I restart mysql on windows?
How do I find the size of a mysql database?
Explain % and _ inside like statement?
How do I edit a table in mysql workbench?
What are procedures in mysql?
How to show certain selected rows with the value "pcds".
How MySQL Optimizes DISTINCT?
What is the difference between char and varchar data types?
How do I change mysql password?
How to set mysql variable in php?
Is mysql is a programming language?
-
Oracle (3239) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3312)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1391)
- Databases AllOther (288)
