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!
![[Web front-end] Node.js quick start](https://img.php.cn/upload/course/000/000/067/662b5d34ba7c0227.png)
