create procedure add_data()
begin
declare i int default 0;
while i<100 do
set i=i+1;
insert into add_test(id, name) value (i,'test_data');
end while;
end;
call add_data();
drop procedure add_data();
create procedure add_data()
begin
declare i int default 0;
while i<100 do
set i=i+1;
insert into add_test(id, name) value (i,'test_data');
end while;
end;
call add_data();
drop procedure add_data();