当前位置: 代码迷 >> 综合 >> 存储过程:标号
  详细解决方案

存储过程:标号

热度:54   发布时间:2024-01-17 03:11:00.0
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语句使程序跳出复杂的复合语句。
  相关解决方案