MySQL的SQL语法和常用函数

begin
……
end;

lable:begin
………..
end lable;

 if 条件 then
 statement
 else
 statement
 end if;

 [label:] WHILE expression DO

 statements

 END WHILE [label] ;

 [label:] LOOP

 statements

 END LOOP [label];

 [label:] REPEAT

 statements

 UNTIL expression

 END REPEAT [label] ;