mysql批量插入语句

CREATE DEFINER = `root`@`192.168.2.%` PROCEDURE `NewProc`()
BEGIN
DECLARE a INT;
set a=0;
WHILE a<100000
DO
INSERT INTO sdkuser(userId,loginName) VALUES(100000001+a,100000001+a);
set a=a+1;
END WHILE;
END;