Showing entries 1 to 1
Displaying posts with tag: LEAVE (reset)
Aug
24
2014
Use of loops in MySQL stored procedures
Posted by Rookie Dev on Sun 24 Aug 2014 03:44 UTC
Tags:

Loops -> Repetitive tasks

3 types of loops in MySQL stored program:
- Simple loop using LOOP and END LOOP clauses
- WHILE and END WHILE clauses that runs while a condition is true
- REPEAT  and UNTIL clauses that runs until a condition is true



Termination of loop -> LEAVE statement.

I will demonstrate the use of loops the simple loop way.

Simple counter from 1 to 10:

Store below stored procedure in a file named my_loop.sql

DELIMITER $$

DROP PROCEDURE IF EXISTS my_loop$$

CREATE PROCEDURE my_loop()
BEGIN
    …

[Read more]
Showing entries 1 to 1