Thursday, February 16, 2012

simple loop syntax with mysql

DELIMITER $$

CREATE

    PROCEDURE `myloop`()
  
    BEGIN
 DECLARE counter INT DEFAULT 0;
           simple_loop: LOOP
             SET counter=counter+10;
             select counter;
             IF counter=50 THEN
                LEAVE simple_loop;
             END IF;
           END LOOP simple_loop;
    END$$

DELIMITER ;

No comments:

Post a Comment