While loop with label : While « Procedure Function « SQL / MySQL

1. SQL / MySQL
2. Procedure Function
3. While

While loop with label

     

DELIMITER $$

CREATE PROCEDURE AGAIN
   (OUT RESULT INTEGER)
BEGIN
   DECLARE COUNTER INTEGER DEFAULT 1;
   SET RESULT = 0;
   LOOP1: WHILE COUNTER <= 1000 DO
      SET COUNTER = COUNTER + 1;
      IF COUNTER > 100 THEN
         LEAVE LOOP1;
      ELSE
         ITERATE LOOP1;
      END IF;
      SET RESULT = COUNTER * 10;
   END WHILE LOOP1;
END$$

DELIMITER ;

   
    
    
    
    
  

Related examples in the same category