First page Back Continue Last page Image

Control Statements Used In Stored Procedures

IF...ELSEIF...ELSE

CASE...WHEN...ELSE

WHILE...DO...LOOP

REPEAT...UNTIL...END REPEAT

DECLARE CURSOR FOR

DECLARE...HANDLER

All of these Control Statements can be used in a Stored Procedure

Branching Command Options

Looping Command Options

Error Handling