MySQL Double loop example

BEGIN    DECLAREmenu_idVARCHAR( $); DECLAREDoneINT DEFAULTFALSE; DECLARECursor_ruleCURSOR  for SELECTS.id fromD_menu_type s; DECLARE CONTINUEHANDLER for  notFOUNDSETDone=TRUE; OPENCursor_rule; L:loopFETCHCursor_rule intomenu_id; IFDone ThenLEAVE L; END IF; BEGIN                                                            DECLAREproperty_idVARCHAR( $); DECLAREDone2INT DEFAULTFALSE; DECLARECursor_rule2CURSOR  for SELECTproperty_id fromD_menu_property LWHEREl.menu_id=menu_id; DECLARE CONTINUEHANDLER for  notFOUNDSETDone2=TRUE; OPENCursor_rule2; L2:loopFETCHCursor_rule2 intoproperty_id; IFDone2 ThenLEAVE L2; END IF; ENDLOOP; CLOSECursor_rule2; END; ENDLOOP; CLOSECursor_rule;END

MySQL Double loop example