Interested to Buy Any Domain ? << Click Here >> for more details...
What are the features of Stored Procedures in MYSQL?
- 1 Answers
- 1409 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 tune a mysql query?
1)for snapshot replication which agents used? 2)for Transcation replication which agents used? 3)for merge replciation which agents used?
Does mysql support nosql?
What is insert query in mysql?
How to create table with same structure of student table in mysql?
What is mysql slow query?
List some comparisons operators used in mysql?
How to run a sql statement?
What is maximum size of a database in MySQL?
13 Answers Bastioncoup, CIS, NM, V2 Solutions, Wipro,
What is longblob in mysql?
What are the differences between a primary key and foreign key?
Explain Access Control Lists.
-
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)
