Latest Tutorials| Questions and Answers|Ask Questions?|Site Map



Home Sql Sql-functions Mysql Looping

Related Tutorials


 
 

Share on Google+Share on Google+

Mysql Looping

Advertisement
Looping in Mysql is a simple loop construct,that enables the repeated execution of the statement list.

Mysql Looping

     

Looping in Mysql is a simple loop construct,that enables the repeated execution of the statement list.This include one or more statements.Each statement is terminated by a semicolon(;). The statement inside a loop are repeated untill the loop is existed.The Leave statement is used to accomplished.

Understand with Example

The Tutorial illustrate an example from 'Mysql Looping'.To understand this example we create a procedure 'ABC' that include  BEGIN-END label consists of declare variable.The set keyword is used to set the value of variable 'a'.The loop runs within the block till the value of variable 'a' become 3.The Loop will be terminated once variable become more than 3.The loop is existed from the statement list.

 

 

 

Query to Create Procedure named ABC:

mysql> drop procedure if exists ABC;
    ->  CREATE PROCEDURE ABC()
    ->             BEGIN
    ->             DECLARE a INT Default 0 ;
    ->             simple_loop: LOOP
    ->               SET a=a+1;
    ->               select a;
    ->               IF a=3 THEN
    ->                  LEAVE simple_loop;
    ->               END IF;
    ->             END LOOP simple_loop;
    ->      ENDGG
Query OK, 0 rows affected, 1 warning (0.00 sec)
Query OK, 0 rows affected (0.06 sec)

Output :

mysql> call abc();
    -> GG
+------+
| a    |
+------+
|    1 |
+------+
1 row in set (0.02 sec)
+------+
| a    |
+------+
|    2 |
+------+
1 row in set (0.22 sec)
+------+
| a    |
+------+
|    3 |
+------+
1 row in set (0.42 sec)
Query OK, 0 rows affected (1.30 sec)
Advertisements

If you enjoyed this post then why not add us on Google+? Add us to your Circles



Liked it!  Share this Tutorial


Follow us on Twitter, or add us on Facebook or Google Plus to keep you updated with the recent trends of Java and other open source platforms.

Posted on: January 16, 2009

Related Tutorials

Discuss: Mysql Looping  

Post your Comment


Your Name (*) :
Your Email :
Subject (*):
Your Comment (*):
  Reload Image
 
 
Comments:0
DMCA.com