MySQL control statements

14.6.5.1 Case Syntax

14.6.5.2 IF Syntax

14.6.5.3 Iterate Syntax

14.6.5.4 LEAVE Syntax

14.6.5.5 LOOP Syntax

14.6.5.6 REPEAT Syntax

14.6.5.7 RETURN Syntax

14.6.5.8 while Syntax

Case USAGE:

Two ways to use:

IF usage:

Looping statements: Iterate Syntax

Iterate is used only in loop,repeat,while; iterate, refers to the next cycle to begin.

14.6.5.4 LEAVE Syntax

LEAVE label, exit the control flow.

LEAVECan be used within BEGIN ... END or loop constructs ( LOOP , REPEAT , WHILE ).

Loop,

REPEAT,

Delimiter//
CREATE PROCEDURE dorepeat (p1 int)
Begin
Set @x=0;
Repeat
Set @[email protected]+1;
Until @x>p1
End repeat;
Select @x;
End//
Call Dorepeat (1000);

While,

CREATE PROCEDURE dowhile () BEGIN  DECLARE v1 INT DEFAULT 5;  While v1 > 0 do    ...    SET v1 = v1-1;  END while; END;

MySQL control statements