MySQL Stored routines (procedures and functions)

Help us to keep this website almost Ad Free! It takes only 10 seconds of your time:
> Step 1: Go view our video on YouTube: EF Core Bulk Extensions
> Step 2: And Like the video. BONUS: You can also share it!

Parameters

ParameterDetails
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.

Remarks

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.



Got any MySQL Question?