MySQL Random password Generation code _MYSQL

Copy code code as follows:

DELIMITER $$

CREATE
FUNCTION ' T_girl '. ' Func_rand_string ' (f_num tinyint unsigned, f_type tinyint)
RETURNS varchar (32)
BEGIN
--Translate the number to letter.
--No 1 stands for string.
--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;

Invoke Method Example:

Copy Code code as follows:

Select Func_rand_string (12,3);