MySQL in (store) function

(store) function:

function, also referred to as "storage function", is actually JS or php in the said function!

The only difference:

the function here must return a data (value);

definition form:

Precautions:

1, within the function, can have a variety of variables and the use of process control;

2, within the function, you can also have a variety of additions and deletions to change the statement;

3, within the function, There can be no select or other "return result set" Query class statement;

Example:

invocation form:

same as calling internal functions! For example:

Select Now (), 8+3 as F2, func1 (); here,now() is a system function; func1 () is a custom function.

Or, if you are in a programming statement:

Set @v1 = Now ();

Set @v2 = Func1 ();

To delete a function:

The name of the drop function function;

MySQL in (store) function