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
//