repeat循环游标:
代码如下:
/*创建过程*/ DELIMITER// DROPPROCEDUREIFEXISTStest// CREATEPROCEDUREtest() BEGIN DECLAREdoneINTDEFAULT0; DECLAREaVARCHAR(200)DEFAULT''; DECLAREcVARCHAR(200)DEFAULT''; DECLAREmycursorCURSORFORSELECTfusernameFROMuchome_friend; DECLARECONTINUEHANDLERFORNOTFOUNDSETdone=1; OPENmycursor; REPEAT FETCHmycursorINTOa; IFNOTdoneTHEN SETc=CONCAT(c,a);/*字符串相加*/ ENDIF; UNTILdoneENDREPEAT; CLOSEmycursor; SELECTc; END// DELIMITER; |
代码如下:
/*创建过程*/ DELIMITER// DROPPROCEDUREIFEXISTStest// CREATEPROCEDUREtest() BEGIN DECLAREdoneINTDEFAULT0; DECLAREaVARCHAR(200)DEFAULT''; DECLAREcVARCHAR(200)DEFAULT''; DECLAREmycursorCURSORFORSELECTfusernameFROMuchome_friend; DECLARECONTINUEHANDLERFORNOTFOUNDSETdone=1; OPENmycursor; REPEAT FETCHmycursorINTOa; IFNOTdoneTHEN SETc=CONCAT(c,a);/*字符串相加*/ ENDIF; UNTILdoneENDREPEAT; CLOSEmycursor; SELECTc; END// DELIMITER; |