MariaDB SQL 반복문 | 데이터카페

MariaDB SQL 반복문

MariaDB에는 반복문은 세 가지의 있습니다.
 - LOOP
 - REPEAT
 - WHILE

LOOP
SQL
DECLARE VAL_COUNT INT DEFAULT 1;
 LOOP_TEST: LOOP
     SET VAL_COUNT = VAL_COUNT + 1;
     IF VAL_COUNT >= 10 THEN
         LEAVE LOOP_TEST;
     END IF;
 END LOOP;


REPEAT
SQL
 DECLARE VAL_count INT DEFAULT 1;
 REPEAT
    SET VAL_count = VAL_count + 1; 
    SELECT VAL_count;
    UNTIL VAL_count >= 10
 END REPEAT;


WHILE
SQL
WHILE count < 10 DO
  SET count = count + 1;
END WHILE;