BEGIN, WHILE, ITERATE, LOOP, and etc...
-
BEGIN END
Syntax: [begin_label:] BEGIN [statement_list] END [end_label]Descriptio... -
CASE STATEMENT
Syntax: CASE case_value WHEN when_value THEN statement_list [WHEN w... -
CLOSE
Syntax: CLOSE cursor_nameDescription: This statement closes a previously op... -
DECLARE CONDITION
Syntax: DECLARE condition_name CONDITION FOR condition_value condition_val... -
DECLARE CURSOR
Syntax: DECLARE cursor_name CURSOR FOR select_statementDescription: This st... -
DECLARE HANDLER
Syntax: DECLARE handler_type HANDLER FOR condition_value [, condition_value] ... st -
DECLARE VARIABLE
Syntax: DECLARE var_name [, var_name] ... type [DEFAULT value]Description: ... -
FETCH
Syntax: FETCH cursor_name INTO var_name [, var_name] ...Description: This s... -
IF statement
Syntax: IF search_condition THEN statement_list [ELSEIF search_conditio... -
ITERATE
Syntax: ITERATE labelDescription: ITERATE can appear only within LOOP, REPE... -
LEAVE
Syntax: LEAVE labelDescription: This statement is used to exit the flow con... -
LOOP
Syntax: [begin_label:] LOOP statement_list END LOOP [end_label]Descript... -
OPEN
Syntax: OPEN cursor_nameDescription: This statement opens a previously declared cursor. -
REPEAT LOOP
Syntax: [begin_label:] REPEAT statement_list UNTIL search_condition END... -
RETURN
Syntax: RETURN exprDescription: The RETURN statement terminates execution o... -
SELECT INTO
Syntax: SELECT col_name [, col_name] ... INTO var_name [, var_name] ...... -
SET VARIABLE
Syntax: SET var_name = expr [, var_name = expr] ...Description: The SET sta... -
WHILE
Syntax: [begin_label:] WHILE search_condition DO statement_list END WHI...