What is MySQL Stored Procedure?



What is MySQL Stored Procedure?..

Answer / hrindows@gmail.com

A procedure (often called a stored procedure) is a collection of pre-compiled SQL statements stored inside the database. It is a subroutine or a subprogram in the regular computing language.
A procedure always contains a name, parameter lists, and SQL statements.
We can invoke the procedures by using triggers, other procedures and applications such as Java,Python,PHP etc. It was first introduced in MySQL version 5. Now almost, it can be supported by almost all relational database systems.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More MySQL Interview Questions

How do I completely remove mysql from windows?

0 Answers  


Is mysql written in c?

0 Answers  


What is the difference between truncate and delete in mysql?

0 Answers  


How to run 'mysql' commands from a batch file?

0 Answers  


How do I start mysql in linux?

0 Answers  






What is the difference between unix timestamps and mysql timestamps?

0 Answers  


How do I rename a mysql database?

0 Answers  


how to find max salary from the database

3 Answers  


What is the use of mysqli_num_rows?

0 Answers  


what is constraints?

0 Answers  


How do you login to MySql using Unix shell?

0 Answers  


What is slow query log in mysql?

0 Answers  


Categories