MySQL Branch and loop structure

1. If Else branch

1 Create procedurePD_TESTIF2 (inchNumint, outStr varchar)2     begin 3         ifNum=1  Then4         Set Str='a';5ElseIf num=2  Then6         Set Str='two';7         End if;8     End;9 --calledTenCall PD_TESTIF2 (1,@str); One Select @str;

Execution Result: a

2. Circulation

1 Create procedurePd_testwhile22 (inchNumint, outsum int)2     begin3         --Defining Variables4         DeclareIint default 1;5         Declare sum int default 0;6        --Cycle Conditions7          whileI<Num do8         SetVsum=Vsum+i;9         SetI=I+1;Ten         --End Loop One         End  while; A         Set sum=vsum; - End; -Call Pd_testwhile22 ( -,@str); the Select @str;

Execution Result: 5050

MySQL Branch and loop structure