本文主要是介绍存储过程:标号，希望对大家解决编程问题提供一定的参考价值，需要的开发者们随着小编来一起学习吧！
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语句使程序跳出复杂的复合语句。
这篇关于存储过程:标号的文章就介绍到这儿，希望我们推荐的文章对编程师们有所帮助！
