Interested to Buy Any Domain ? << Click Here >> for more details...
What are the features of Stored Procedures in MYSQL?
- 1 Answers
- 1364 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 |
using primary can we relate two table, with out foreign key?
Why do we use preparedstatement?
Explain the difference between mysql_fetch_array(), mysql_fetch_object()?
Ondelete clause is specified with a.)Drop table b.)Delete command c.)Create table d.)Select command
How do I run a query in mysql?
How can you retrieve a particular number of records from a table?
How do I edit a table in mysql workbench?
How can we change the name of a column of a table?
What is mysql connection limit?
What are the disadvantages of stored procedures?
What does mysqli stand for?
How do I restart mysql on windows?
-
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)
