Why do we write stored procedures?



Why do we write stored procedures?..

Answer / Meghnath

Stored procedures are written to encapsulate SQL logic and improve code reusability, maintainability, and performance. They can perform complex tasks, handle transactions, enforce security, and reduce the need for repeating the same queries multiple times.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More MySQL Interview Questions

How to show table structure mysql?

1 Answers  


How to start mysql server?

1 Answers  


Why phpmyadmin is used for mysql?

1 Answers  


How to store binary data in mysql?

1 Answers  


What is flush privileges in mysql?

1 Answers  


How do you determine the location of mysql data directory?

1 Answers  


What is inner join in mysql?

1 Answers  


Explain the difference between BOOL, TINYINT and BIT?

1 Answers  


What is logs in mysql?

1 Answers  


how to find 2nd highest salary in random database salary of employer.....

4 Answers  


How is myisam table stored?

1 Answers  


What does tinyint mean?

1 Answers  


Categories