Overview ...
1.Case Syntax
2.If Syntax
3.Iterate Syntax
4.Leave Syntax
5.Loop Syntax
6.Repeat Syntax
7.Return Syntax
8.While Syntax
MySQL supports the,,,, IF
CASE
ITERATE
LEAVE
LOOP
WHILE
, and REPEAT
constructs for flow control within stored programs. It also supports RETURN
within stored functions.
MySQL does not a support FOR
loops.
(1) Case Syntax
case_value
when_value
statement_list
when_value
statement_list
] ... statement_list
]end case
Case] ... search_condition
statement_list
search_condition
statement_list
statement_list
]end case
The CASE
statement for stored programs implements a complex conditional construct.
Note
There is also a CASE
expression, which differs from the statement descr CASE
ibed here. See section 12.4, "Control Flow Functions". The statement cannot has an ELSE NULL
clause, and it's terminated with END CASE
instead of END
. CASE
MySQL (Flow Control statements)