Interested to Buy Any Domain ? << Click Here >> for more details...
What are the features of Stored Procedures in MYSQL?
- 1 Answers
- 1361 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 can I see connections in mysql?
If you wish to encrypt the username and password using php, how will you do that?
What is data node in mysql cluster?
What mysql -u john -p command does?
How do I change the max connection in mysql?
How can you filter the duplicate data while retrieving records from the table?
In which format data is stored in mysql database?
How to display nth highest salary from a table in a mysql query?
How to calculate the difference between two dates?
Can I install mysql on mac?
Create table employee (eno int(2),ename varchar(10)) ?
what is mySQL. Is there any specific qualification required to do this course ? What is the scope in India after doing mySQL
-
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)
