DROP procedure IF EXISTS insertdata;
create procedure insertdata(in size int)
begin
declare v int;
declare name varchar(40);
declare data varchar(255);
set v=0;
repeat
set name = CONCAT('name',v);
set data= CONCAT('data',v);
insert into test(name,data) values("111", "222");
set v=v+1;
until v >=size