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;