1、创建表:
create test_a( id int);
2、创建存储过程
delimiter $$
create procedure batch_insert()begin
DECLARE max int;
DECLARE rc int;
set max =10000;
set rc =1;
loopl: while rc<max do
insert into test_a values(rc);
set rc=rc+1;
end while loopl;
end$$
delimiter ;
3、调用存储过程:
call batch_insert();