fastread homefastrread library fastread menu

MariaDB : LEAVE Statement

Tutorial by:      Date: 2016-04-18 05:54:33

❰ Previous Next ❱

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

Description

In MariaDB, 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 MariaDB 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 MariaDB:

DELIMITER //

 

CREATE FUNCTION CalcValue ( starting_value INT )

RETURNS INT DETERMINISTIC

 

BEGIN

 

   DECLARE total_value INT;

 

   SET total_value = 0;

 

   label1: LOOP

     SET total_value = total_value + starting_value;

     IF total_value < 999 THEN

       ITERATE label1;

     END IF;

     LEAVE label1;

   END LOOP label1;

 

   RETURN total_value;

 

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 total_value is less than 999. Once total_value is greater than or equal to 999, the LEAVE statement would terminate the LOOP.

 

❰ Previous Next ❱


MariaDB

Submit Your Thought, Tutorial, Articls etc.

Submit Your Information India's Number one online promotion website