Use of MySQL cursor loops

CREATE PROCEDURE' test '. ' New_procedure ' ()BEGINDECLAREDoneINT DEFAULTFALSE; --you need to define variables that receive cursor data  DECLAREACHAR( -); --Cursors  DECLARECurCURSOR  for SELECTI fromtest.t; --Traverse data End Flag  DECLAREDoneINT DEFAULTFALSE; --binding the end flag to a cursor  DECLARE CONTINUEHANDLER for  notFOUNDSETDone=TRUE; --Open Cursor  OPENCur1; --Start LoopRead_loop:loop--extract the data in the cursor, there is only one, many words are the same;    FETCHCur intoA; --at the end of the statement    IFDone ThenLEAVE Read_loop; END IF; --here do the loop events you want to do    INSERT  intotest.tVALUES(a); ENDLOOP; --Close Cursors  CLOSECur1;END

Use of MySQL cursor loops