What is MySQL Stored Procedure?

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain csv tables.

545


What is meant by mysqli?

487


What are the security alerts while using mysql?

567


what is constraints?

618


Is oracle better than mysql?

461






How to enable or disable a row of a table using MySQL in struts?

3563


What is regexp?

646


How do I change a procedure in mysql?

473


What tools available for managing mysql server?

530


What is the difference between float and double?

585


Write a query to create a database and a table?

483


What is timestamp in mysql?

550


What is a deterministic function?

589


How can we run batch mode in mysql?

532


How to update a root password.

525