Stored Procedure in MySQL Server
Stored Procedure is a collection of SQL commands and this is not executed until or unless called but compiled at the time of creation. Thus, this helps to reduce execution time and increases Data Integrity as well. In MySQL Server, Stored Procedure accepts three types of argument.
1) IN
2) OUT
3) INOUT
Continue reading