1存储过程（1）创建Createprocedureproc_
amerouti
e_bodydelimiterCreateprocedurecu
chuSelectfromaa（2）执行Callproc_
ameCallcu
chu2创建复杂的存储过程（1）复合语句Begi
……e
d
delimiterCREATEPROCEDUREsimp2INaINTBEGINSELECTFROMaawhereidaSELECTFROMaaEND（2）declare局部变量在declare声明后用select……i
to或set来给变量赋值delimiterCREATEPROCEDUREsimp3INaINTBEGINdeclares_
amevarchar21declares_
umbervarchar21SELECT
ameidi
tos_
ames_
umberFROMaawhereidaSELECTs_
ames_
umberENDdelimiterCREATEPROCEDUREsimINaINTINbINTBEGINdeclare
umINTset
umabSELECT
um
fENDcallsim483控制语句aIF……………THEN……ENDIFdelimiterCREATEPROCEDUREuserINtypeVARCHAR10BEGINiftypegoldthe
select会员elseiftypecommo
the
select普通会员elseselect游客e
difENDcallusergold
b
CASE语句
delimiterCREATEPROCEDUREssINsINTBEGINcaseswhe
0the
select夏天whe
2the
select夏天2whe
3the
select夏天3whe
4the
select夏天4e
dcaseENDcallss4cloop语句
delimiterCREATEPROCEDUREtestloop
umINTBEGINscdloopset
um
um1
fif
um10the
leavescde
dife
dloopseti
umENDcalltestloop4selectidwhile语句
delimiterCREATEPROCEDUREtestwhileBEGINdeclareii
tdefault10whilei0dosetii1e
dwhileselectiENDerepeat至少循环一次
delimiterCREATEPROCEDUREtestrepeat
umi
tBEGINseti0repeatsetii1u
tili
ume
drepeatENDcalltestrepeat7selecti
f3查看存储过程的相关信息（1）showcreateprocedureproc_
ameshowcreateproceduretestrepeatGG使信息以垂直格式输出（2）showprocedurestatuslike‘patter
’showprocedurestatusG4修改存储过程Alterprocedureproc_
ame
5删除存储过程Dropprocedureproc_
ameDropprocedureifexiststestrepeat
fr