1.变量
定义方法:(1)set @a=1;#定义回话变量a,初始化为1.
(2)declare n char(20) default '123';#定义常规变量;
赋值方法:(1)set @a=1;
(2)select num into @a form book;
(3)select @a:=num form book;#注:=有时会被误解成比较运算符。
2.复合语句
begin ... end 相当于C语言的{}
3.条件语句
(1)if语句
if ... then #相当于if(...)
...
elseif ... then #相当于else if(...)
...
else
...end if
(2)case语句
case ...
when ... then ...
when ... then ...
else ...end case
4.循环语句
(1)while语句
while ... do
...end while
(2)repeat until 语句 #相当于do while语句
repeat
...
until ...#写循环条件end repeat
(3)loop语句
label:lopp
...
leave label; #相当于break
iterate label; #相当于continueend loop label
5.游标
6.异常