create procedure loop_leave_iterate_test()
begin
set @i=0;
set @j=0;
ins:loop
if @i<5
then set @j=@j+1;
if@j=5 then
iterate ins;#跳过本轮循环
end if;
set @i=@i+1;
elseif @i>=5
then
select @i,@j;
leave ins;#结束loop循环
end if;
end loop;
end;
call loop_leave_iterate_test();
drop procedure loop_leave_iterate_test;