MySQL (Flow Control statements)

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_valuestatement_list    when_valuestatement_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)