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.

Write a command to view mysql database table structure?

968

---

What is meant by decimal (5,2)?

1029

---

What is the data type for image?

1068

---

How to upload a large file through phpmyadmin in mysql?

957

---

What is database engine in mysql?

937

---

What is difference between microsoft sql and mysql?

995

---

What is offset limit?

961

---

How to give user privilages for a db. Login as root. Switch to the mysql db. Grant privs. Update privs.

933

---

write a command to view the content of the table

899

---

What is mysql in dbms?

1031

---

How to display odd rows in student table in mysql?

1007

---

What is the command line end user interface - mysql?

1083

---

Where does mysql store data?

879

---

How do I find the size of a mysql database?

916

---

Why do you think it is advised to not to use guid and character columns as clustered index arrays?

1122

---