mysql 变量存储过程

DROP PROCEDURE IF EXISTS proc_initData; -- 如果存在此存储过程则删掉
CREATE PROCEDURE proc_initData()
BEGIN
    DECLARE i INT DEFAULT 1;
        DECLARE idV INT DEFAULT 1;
        DECLARE usernamePrefix VARCHAR(100) DEFAULT 'arseeutest';
        DECLARE pass VARCHAR(100) DEFAULT '123456';
        START TRANSACTION; -- 为存储过程指定一个事务 
    WHILE i <= 100 DO
                SELECT(CONCAT(usernamePrefix, i+""));
                SET idV = i + 10;
                INSERT INTO `user_info`(`id`, `user_name`, `password`) VALUE (idV, CONCAT(usernamePrefix, i+""), MD5(pass));
        SET i = i+1;
    END WHILE;
        COMMIT;  
END;
CALL proc_initData();

此存储过程为批量存储数据