晚上有朋友问起，简单的写了一个。
- DELIMITER $$
- CREATE
- FUNCTION `t_girl` . `func_rand_string` ( f_num tinyint unsigned , f_type tinyint unsigned )
- RETURNS varchar ( 32)
- BEGIN
- -- Translate the number to letter.
- -- No 1 stands for string only.
- -- No 2 stands for number only.
- -- No 3 stands for combination of the above.
- declare i int unsigned default 0;
- declare v_result varchar ( 255) default '' ;
- while i < f_num do
- if f_type = 1 then
- set v_result = concat ( v_result, char ( 97+ ceil( rand ( ) * 25) ) ) ;
- elseif f_type= 2 then
- set v_result = concat ( v_result, char ( 48+ ceil( rand ( ) * 9) ) ) ;
- elseif f_type= 3 then
- set v_result = concat ( v_result, substring ( replace ( uuid ( ) , '-' , '' ) , i+ 1, 1) ) ;
- end if;
- set i = i + 1;
- end while;
- return v_result;
- END $ $
- DELIMITER ;
调用方法示例：文章源自很文博客https://www.hinven.com很文博客-https://www.hinven.com/50333.html
- select func_rand_string(12,3);
我的微信
扫一扫更精彩
大家的支持是我更新的动力！！！
评论