语法
自定义函数也需要相应的要求,语法如下:
CREATE FUNCTION(参数列表)
RETURNS返回值类型
函数体
删除:
DROPFUNCTION
调用自定义函数语法:
SELECT (parameter_value,...)
语法实例
create function rand_string(n int) returns varchar(255)
begin
declare chars_str varchar(100) default 'abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789';
declare return_str varchar(255) default '';
declare i int default 0;
while i < n do
set return_str = concat(return_str, substring(chars_str,floor(1+rand()*62),1));
set i= i+1;
end while;
return return_str;
end;
效果
这样我们自己定义的函数就完成了,先来看看FUNCTION属性及运行效果;
mysql> show function status;
+------+-------------+----------+----------------+---------------------+---------------------+---------------+---------+----------------------+----------------------+--------------------+
| Db | Name | Type | Definer | Modified | Created | Security_type | Comment | character_set_client | collation_connection | Database Collation |
+------+------------