自动安插数据的mysql procedure

自动插入数据的mysql procedure

DROP procedure IF EXISTS insertdata;create procedure insertdata(in size int)begindeclare 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