存储过程实例（续）mysql

1、while do

drop procedure if exists pro_while;
delimiter ;;
create procedure pro_while()
begin
	declare i int;
	set i = 0;
	while i < 10 do
		select concat('index:',i);
		set i = i + 1;
	end while;
end
;;
delimiter ;
call pro_while();

2、repeat

drop procedure if exists pro_repeat;
delimiter ;;
create procedure pro_repeat(in parameter int)
begin
     declare var int;  
     set var = parameter; 
     repeat
			 set var = var - 1; 
			 set parameter = parameter -2; 
     until var < 0
     end repeat;
     select parameter;
end
;;
delimiter ;
set @param=1;
call pro_repeat(@param);

3、loop

drop procedure if exists pro_loop;
delimiter;;
create procedure pro_loop(in parameter int)
BEGIN
	declare var int;  
	set var = parameter; 
	loop_label: loop
		set var = var - 1; 
		set parameter = parameter -2; 
		if var < 0 then
			leave loop_label;
		end if;
	end loop;
	select parameter;
END
;;
delimiter;
set @parameter=4;
call pro_loop(@parameter);