MySQL: LEAVE Statement

最新推荐文章于 2024-11-18 01:45:00 发布

weixin_34245082

最新推荐文章于 2024-11-18 01:45:00 发布

阅读量261

点赞数

文章标签：数据库 php

原文链接：http://www.cnblogs.com/kungfupanda/p/5894841.html

版权

https://www.techonthenet.com/mysql/loops/leave.php

This MySQL tutorial explains how to use the LEAVE statement in MySQL with syntax and examples.

Description

In MySQL, the LEAVE statement is used when you want to exit a block of code identified by a label_name, such as a LOOP statement, WHILE statement, or REPEAT statement.

Syntax

The syntax for the LEAVE statement in MySQL is:

LEAVE label_name;

Parameters or Arguments

label_name

The name of the block of code (ie: LOOP, WHILE, REPEAT) to terminate.

Note

You use the LEAVE statement to terminate a block of code, such as a LOOP statement, WHILE statement, or REPEAT statement that is identified by a label_name.

Example

Let's look at an example that shows how to use the LEAVE statement in MySQL:

DELIMITER //

CREATE FUNCTION CalcIncome ( starting_value INT )
RETURNS INT

BEGIN

   DECLARE income INT;

   SET income = 0;

   label1: LOOP
     SET income = income + starting_value;
     IF income < 3000 THEN
       ITERATE label1;
     END IF;
     LEAVE label1;
   END LOOP label1;

   RETURN income;

END; //

DELIMITER ;

In this LEAVE example, we have created a loop called label1 using the LOOP statement.

The ITERATE statement would cause the loop to repeat while income is less than 3000. Once income is greater than or equal to 3000, the LEAVE statement would terminate the LOOP.

转载于:https://www.cnblogs.com/kungfupanda/p/5894841.html