//创建过程
CREATE PROCEDURE proc_single(IN num INT)
BEGIN
SET @count=0;
WHILE @count < num DO
INSERT INTO test(uid) VALUES(1);//自己的sql语句
SET @count = @count + 1;
END WHILE;
END
//调用过程
call proc_single(100000);
//创建过程
CREATE PROCEDURE proc_single(IN num INT)
BEGIN
SET @count=0;
WHILE @count < num DO
INSERT INTO test(uid) VALUES(1);//自己的sql语句
SET @count = @count + 1;
END WHILE;
END
//调用过程
call proc_single(100000);