How to create a function in mysql

How to create a function in mysql: first check whether the function of creating a function is turned on; then if the value at Value is OFF, you need to turn it on; then when creating the function, first select the database; finally test it .

More related free learning recommendations:mysql tutorial(video)

How to create a function in mysql:

1. Check whether the function of creating a function is turned on:

mysql> show variables like '%func%'; +-----------------------------------------+-------+ | Variable_name | Value | +-----------------------------------------+-------+ | log_bin_trust_function_creators | ON | +-----------------------------------------+-------+ 1 row in set (0.02 sec)

2. If the value at Value is OFF, you need to turn it on.

mysql> set global log_bin_trust_function_creators=1;

3. When creating a function, select the database first.

mysql> use xxx; Database changed delimiter $$是设置 $$为命令终止符号，代替分号，因为分号在begin...end中会用到； mysql> delimiter $$ CREATE FUNCTION first_func(param1 varchar(5),parmam2 varchar(5),param3 varchar(10)) RETURNS TINYINT BEGIN RETURN 1; END

After the function is successfully created, the semicolon must be restored as the command termination symbol.

mysql> delimiter ;

4. Test:

mysql> select first_func('aaa','bbb','ccc'); +-------------------------------+ | first_func('aaa','bbb','ccc') | +-------------------------------+ | 1 | +-------------------------------+ 1 row in set (0.47 sec)

5. Delete function:

mysql> drop function first_func ; Query OK, 0 rows affected (0.11 sec)

6. View function

1 ) show function status

Display basic information of all functions in the database

2) View a specific function

mysql>show create function function;

The above is the detailed content of How to create a function in mysql. For more information, please follow other related articles on the PHP Chinese website!