참고
MySQL Documentation 13.6.5.5 LOOP Statement
설명
- 하나 이상의 statement를 반복적으로 실행할 수 있도록 루프구조를 구현하는데 사용
- 각 statement는 세미콜론(;)으로 …
MySQL Documentation 13.6.5.5 LOOP Statement
MySQL Documentation 13.1.17 CREATE PROCEDURE and CREATE FUNCTION Statements
MySQL Documentation 13.6.5.6 REPEAT Statement
MySQL Documentation 13.3.1 START TRANSACTION, COMMIT, and ROLLBACK Statements
START TRANSACTION
[transaction_characteristic [, transaction_characteristic] ...]
transaction_characteristic: {
WITH CONSISTENT SNAPSHOT
| READ WRITE
| READ ONLY
}
BEGIN [WORK]
COMMIT [WORK] [AND [NO] CHAIN] [[NO] RELEASE …
MySQL Documentation 13.6.2 Statement Labels
[begin_label:] BEGIN
[statement_list]
END [end_label]
[begin_label:] LOOP
statement_list
END LOOP [end_label]
[begin_label:] REPEAT
statement_list
UNTIL search_condition
END REPEAT [end_label]
[begin_label:] WHILE search_condition DO
statement_list …
MySQL Documentation 13.6.5.8 WHILE Statement
[begin_label:] WHILE search_condition DO
statement_list
END WHILE [end_label]
CREATE PROCEDURE dowhile()
BEGIN
DECLARE v1 INT …