mysql游標(biāo)

1、游標(biāo)定義DECLAREcurs_nameCURSF_statement游標(biāo)操作OPEN打開游標(biāo)OPENcurs_nameFETCH獲取游標(biāo)當(dāng)前指針的記錄，并傳給指定變量列表注意變量數(shù)必須與游標(biāo)返回的字段數(shù)一致要獲得多行數(shù)據(jù)，使用循環(huán)語句去執(zhí)行FETCHFETCHcurs_nameINTOvariablelistCLOSE關(guān)閉游標(biāo)CLOSEcurs_name注意:mysql的游標(biāo)是向前只讀的也就是說，你只能順序地從開始往后讀取結(jié)果集，不能

2、從后往前，也不能直接跳到中間的記錄.示例:初始化procedureifexistsuseCurs建立存儲(chǔ)過程createCREATEPROCEDUREuseCurs()BEGIN局部變量的定義declaredeclaretmpNamevarvar(2020)defaultdeclareallNamevarvar(255255)defaultdeclarecur1CURSFnameFROMtest.levelleveldeclareCON

3、TINUEHLERFSQLSTATE02000SETtmpname=null開游標(biāo)OPENcur1游標(biāo)向下走一步FETCHcur1INTOtmpName循環(huán)體這很明顯把游標(biāo)查詢出的name都加起并用號(hào)隔開WHILE(tmpnameisnotnull)DOsettmpName=CONCAT(tmpName““)setallName=CONCAT(allNametmpName)游標(biāo)向下走一步FETCHcur1INTOtmpNameENDWH

4、ILECLOSEcur1allNameENDcalluseCurs()createproceduretest_proc_curs()begindeclareidintdeclarenamevar(50)declaresexvar(50)declareageintdeclareIS_FOUNDintdefault1聲明游標(biāo)DECLAREpCURSFFROMstudentDECLARECONTINUEHLERFNOTFOUNDSETIS_F