Mysql自定义函数批量插入随机字符串

DELIMITER // -- 修改MySQL delimiter：'//'


DROP FUNCTION IF EXISTS `rand_string` //

CREATE FUNCTION `rand_string` (n INT) RETURNS VARCHAR(255) CHARSET 'utf8'
BEGIN 
    DECLARE char_str varchar(100) DEFAULT 'abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789';
    DECLARE return_str varchar(255) DEFAULT '';
    DECLARE i INT DEFAULT 0;
    WHILE i < n DO
        SET return_str = concat(return_str, substring(char_str, FLOOR(1 + RAND()*62), 1));
        SET i = i+1;
    END WHILE;
    RETURN return_str;
END //

DROP FUNCTION IF EXISTS `big_insert` //
CREATE FUNCTION `big_insert` (n INT) RETURNS VARCHAR(255) CHARSET 'utf8'
BEGIN  
    DECLARE i INT DEFAULT 0;
    WHILE i < n DO
	insert into big (name) value(rand_string(5));
        SET i = i+1;
    END WHILE;
    RETURN 'SUCCESS';
END //
DELIMITER ;

select big_insert(1000) from dual;