MySQL 随机密码生成代码

晚上有朋友问起，简单的写了一个。DELIMITER $$CREATEFUNCTION `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 doif f_type = 1 thenset v_result = concat ( v_result, char ( 97+ ceil( rand ( ) * 25) ) ) ;elseif f_type= 2 thenset v_result = concat ( v_result, char ( 48+ ceil( rand ( ) * 9) ) ) ;elseif f_type= 3 thenset v_result = concat ( v_result, substring ( replace ( uuid ( ) , '-' , '' ) , i+ 1, 1) ) ;end if;set i = i + 1;end while;return v_result;END $ $DELIMITER ;调用方法示例：select func_rand_string(12,3);