MySQL create and invoke functions and procedures

Create a function

Delimiter//Create functionFunction_name ([Parameters])returnsReturn_typebeginDo your WorkEnd//delimiter; Description:1.//can be replaced with $$2the last sentence has a space between the delimiter and the semicolon.3Each parameter must have a parameter name and type, i.e. function_name (nametext)

Calling functions

Function_name ([parameters])

Example:

Create a process

// Create procedure procedure_name ([inparameters[,out parameters]])    Beginworkend//delimiter; it's basically the same way you create a function

Call procedure

Call Procedure_name (In_parameter,@out_parameter);

Example:

References:

Function

Process

MySQL create and invoke functions and procedures