mysql> create table t1(a varchar(200),b varchar(200));
Query OK, 0 rows affected (0.01 sec)
mysql> delimiter $$
mysql> drop procedure if exists p1$$
Query OK, 0 rows affected, 1 warning (0.00 sec)
mysql> create procedure p1()
-> begin
-> set @v_n=1;
-> while @v_n<10000
-> do
-> insert into t1(a,b) values(‘haha’,‘wowo’);
-> set @v_n = @v_n +1;
-> end while;
-> commit;
-> end$$
Query OK, 0 rows affected (0.01 sec)
mysql> delimiter ;
mysql> call p1;
Query OK, 0 rows affected (1.50 sec)
mysql> select count() from t1;
±---------+
| count() |
±---------+
| 9999 |
±---------+
1 row in set (0.00 sec)