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 mysql data directory?
Does mysql support nosql?
What is the insert?
What mysql -u john -p command does?
Why mysql is used with php?
Explain data type TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP .
Is SET Command is SQL Statement..?
What is pdo mysql?
What is the purpose of mysql database?
I want to find out all databases starting with ‘test’, I have access to?
Give the syntax of GRANT commands?
What tools available for managing mysql server?
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)