mysql 自定义sql函数生成指定长度的随机字符串

来源：互联网发布：打印机端口没有usb001 编辑：程序博客网时间：2024/04/29 17:49

不含小写字母：

DELIMITER //DROP FUNCTION IF EXISTS `rand_string` //CREATE FUNCTION `rand_string`(n INT) RETURNS varchar(255) CHARSET utf8BEGIN    DECLARE chars_str varchar(255) DEFAULT 'ABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789';    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()*36 ),1));        SET i = i + 1;    END WHILE;    RETURN return_str;END//select rand_string(9);

result：X7YXE1O1U

含小写字母：

DELIMITER //DROP FUNCTION IF EXISTS `rand_string` //CREATE FUNCTION `rand_string`(n INT) RETURNS varchar(255) CHARSET utf8BEGIN    DECLARE chars_str varchar(255) 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//select rand_string(9);

result：OzhxFAN2C

0 0