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

Can we write pl sql mysql?

502


what is mySQL. Is there any specific qualification required to do this course ? What is the scope in India after doing mySQL

951


What are the steps required to view your mysql database?

610


Which datatype is used for email in mysql?

480


What is 'mysqld'?

506






What are the column comparisons operators?

619


What is the difference between sql and mysql and oracle?

435


What does mysqli_fetch_assoc do?

486


can you tell the order of sql select statement? : Mysql dba

482


How to find the unique values if the value in the column is repeated?

552


What is unsigned in mysql?

506


How to dump one database for backup.

494


What is the difference between unix timestamp and mysql timestamp?

518


What is mysql vs sql?

483


How do I change global variables in mysql?

473