mysql存储过程传入两个参数，循环插入数据

delimiter //

CREATE PROCEDURE p7(IN min INT, IN max INT)
MODIFIES SQL DATA
BEGIN
DECLARE iStart INT;
DECLARE iEnd INT;
DECLARE i INT;
DECLARE iCount INT;

SET @iStart = min;
SET @iEnd = max;

SET @i=@iStart;
WHILE (@i < @iEnd) DO
INSERT INTO t_login
SELECT @i, ‘Lovell’, ‘logger,playerInfo’;
SET @i=@i+1;
END WHILE;
END
//