Answer Posted / hrindows@gmail.com

 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.

What is the latest version of mysql?

985

---

How does select query work?

930

---

What language is used in mysql?

987

---

What happens when the column is set to AUTO INCREMENT and if you reach maximum value in the table?

1032

---

How can I insert images into a Mysql database?

1045

---

How do you shutdown a mysql database?

1036

---

How we can get the current date in mysql?

955

---

how can you test for null values in a database? : Mysql dba

928

---

Why should I learn mysql?

909

---

State the differences between mongodb and mysql.

1165

---

How you will Show unique records.

1023

---

What is normalization and list the different types of normalization?

939

---

Is mysql a backend?

922

---

What is the difference between b-tree and hash indexes?

991

---

How to calculate expressions with sql statements?

1108

---