mysql 函数+存储过程 生成百万记录

CREATE TABLE `vote_record` (  
    `id` INT (11) NOT NULL AUTO_INCREMENT,  
    `user_id` VARCHAR (20) NOT NULL,  
    `vote_id` INT (11) NOT NULL,  
    `group_id` INT (11) NOT NULL,  
    `create_time` DATETIME NOT NULL,  
    PRIMARY KEY (`id`),  
    KEY `index_user_id` (`user_id`) USING HASH  
) ENGINE = INNODB AUTO_INCREMENT = 1 DEFAULT CHARSET = utf8 

DELIMITER $$
CREATE FUNCTION `rand_string`(n INT) RETURNS VARCHAR(255) CHARSET utf8  
BEGIN   
DECLARE chars_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(chars_str , FLOOR(1 + RAND()*62 ),1));   
SET i = i +1;   
END WHILE;   
RETURN return_str;   
END $$ 

DELIMITER $$
CREATE  PROCEDURE `add_vote_table`(IN n INT)  
BEGIN    
  DECLARE i INT DEFAULT 1;  
    WHILE (i <= n ) DO  
      INSERT INTO vote_record (user_id,vote_id,group_id,create_time ) VALUES (rand_string(10),FLOOR(RAND() * 1000),FLOOR(RAND() * 100) ,NOW() );  
            SET i=i+1;  
    END WHILE;  
END $$

CALL add_vote_table(1000000);