存储过程:标号

drop procedure if exists p17;

delimiter //

 
create procedure p17 ()  
label_1: begin  
  label_2: while 1 = 1 do 
  	select "循环";
  	leave label_2;  -- 若没此句,为死循环
  end while;  
  
  label_3: repeat 
  	select "循环2";
  	leave label_3; -- 若没此句,为死循环
	  until 0 != 0  
	end repeat;
	  
  label_4: loop 
  	select "循环3";
  	leave label_4; -- 若没此句,为死循环
  end loop;  
end; //  
 

delimiter ;

call p17();


/*
+------+
| 循环 |
+------+
| 循环 |
+------+
1 row in set (0.00 sec)

+-------+
| 循环2 |
+-------+
| 循环2 |
+-------+
1 row in set (0.00 sec)

+-------+
| 循环3 |
+-------+
| 循环3 |
+-------+
1 row in set (0.00 sec)
*/

create procedure p19 (parameter1 char)  
label_1: begin  
  label_2: begin  
    label_3: begin  
      if parameter1 is not null then  
        if parameter1 = 'a' then  
          leave label_1;  
        else begin  
          if parameter1 = 'b' then  
            leave label_2;  
          else  
            leave label_3;  
            end if;  
          end;  
        end if;  
      end if;  
    end;  
  end;  
end;//  

LEAVE语句使程序跳出复杂的复合语句。