Interested to Buy Any Domain ? << Click Here >> for more details...
What are the features of Stored Procedures in MYSQL?
- 1 Answers
- 1268 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 |
What is procedural api?
What happens when the column is set to AUTO INCREMENT and if you reach maximum value in the table?
What is query log in mysql?
Can foreign key have duplicate values?
How to Set a root password if there is on root password.
What is the latest version of php and mysql?
What is flush privileges in mysql?
What is session variable in mysql?
What are the similarities between a function and a procedure?
What are the advantages of a procedure?
What is clob in mysql
How do stored procedures work?
-
Oracle (3259) - 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)
