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

What is the command used to create a database using php and mysql?

848


How to show certain selected rows with the value "pcds".

673


How to create table with same structure of student table in mysql?

689


How do I start mysql server?

649


What is the default port for MySQL Server?

762


How many threads can mysql handle?

680


How many types of indexes are there in mysql?

675


How would you enter characters as hex numbers?

691


Write a query to select all teams that won either 1, 3, 5 or 7 games.

1051


How many columns is too many mysql?

666


What is the query to display top 20 rows?

789


How to run a sql statement?

746


Why we use mysql workbench?

658


Where does mysql store data?

628


table a has records 1,1,1,1 table b has records 1,1,1,1,1,1 what would be out if perform join for all cases

1037