Mysql generates random string function sharing _mysql

Copy Code code as follows:

Set global log_bin_trust_function_creators = 1;
DROP FUNCTION IF EXISTS rand_string;
DELIMITER $$
CREATE FUNCTION rand_string (n INT)
RETURNS VARCHAR (255)
BEGIN
DECLARE chars_str varchar () 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 $$
DELIMITER;

After testing, the function is created to bind to the current database, and the following statement can view information about the function.

Copy Code code as follows:

Show FUNCTION STATUS WHERE db= ' database_name ';