78.一个简单的存储过程

delimiter $$
create table test.t3(id int not null primary key,name varchar(20));
truncate table t3;
drop procedure if exists data;
create procedure data(in i int)
begin
    while i < 100000 do
        insert into test.t3 values(i,'菠萝');
        set i=i+1;
    end while;
end
$$
set @id=1;
call data(@id);