mysql 存储过程简单案例

//创建过程

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);