mysql> create procedure pro10()
-> begin
declare @i int;
-> set @i=1;
-> while @i<5 begin
-> insert into t1(ff) values('第'+ @i +'条');
-> set @i=@i+1;
end
end
declare @i int;
set @i=1;
while i<5
begin
insert into t1(ff) values("第"+ @i +"条");
set @i=@i+1;
end