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

What is the difference between MyISAM Static and MyISAM Dynamic?

0 Answers  


How to connect html form to mysql database using php?

0 Answers  


What is mysql sleep process?

0 Answers  


List data types in mysql? Explain

0 Answers  


What is tee command in mysql?

0 Answers  


How to insert html code into mysql database using php?

0 Answers  


Is mysql still relevant?

0 Answers  


How can a user get the current SQL version?

2 Answers  


What are the functions used to encrypt and decrypt the data present in mysql?

0 Answers  


Is mysql relational database?

0 Answers  


what is collation? how many types of installations in sql server?

3 Answers  


What is the difference between mysql_connect() and mysql_pconnect()?

7 Answers   TCS,


Categories