Stored routines (procedures and functions)

Download mysql eBook


RETURNSSpecifies the data type that can be returned from a function.
RETURNActual variable or value following the RETURN syntax is what is returned to where the function was called from.


A stored routine is either a procedure or a function.

A procedure is invoked using a CALL statement and can only pass back values using output variables.

A function can be called from inside a statement just like any other function and can return a scalar value.

Related Examples


351 Contributors: 10
Monday, May 15, 2017
Licensed under: CC-BY-SA

Not affiliated with Stack Overflow
Rip Tutorial:

Download eBook