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 purpose of using ifnull() function?

0 Answers  


What is A BI Ap;plication?

1 Answers   HCL,


What are date and time data types in mysql?

0 Answers  


How do you start and stop MySQL on Windows?

3 Answers  


How do I connect to mysql database?

0 Answers  






How can increase the performance of MySQL select query?

3 Answers   RV Technologies, Span Systems,


How do you say mysql?

0 Answers  


What is a join? Explain the different types of mysql joins.

1 Answers  


Difference between MYSQL_ASSOC,MYSQL_NUM and MYSQL_BOTH ?

3 Answers   TCS,


How do I edit a trigger in mysql?

0 Answers  


How many values can the SET function of MySQL take?

2 Answers   Creative Informatics,


What are the advantages of myisam over innodb?

0 Answers  


Categories