利用mysql存储过程循环插入新数据并更新

DROPPROCEDUREIFEXISTSexcute_job_v340;createprocedureexcute_job_v340()begindeclarerdevidint;//声明参数declarech_idint;声明lotint；声明new_rech_idint；declarenew_priceDOUBLE;//声明声明参数oneINTDEFAULTFALSE;////声明结束标识参数--游标声明DECLARErdevrech_idCURSORFORselectr.idasrdevid,r.rechargeconfig_idasrech_id,r.slot_noasslotfromb_device_tbldev      LEFTJOINr_fromvice_rechargeconfig_tblrondev.id=r.device_id其中dev.dev_typedef_id=7anddev.masteridisnotNULLandr.rechargeconfig_type=4andr.is_deleted=0and      r.slot_noisnot NULL;--将结束指示器绑定到滑块         NTINUEHANDLERFORNOTFOUNDSETdone=TRUE;--打开滑块OPENrdevrech_id;--遍历read_loop:LOOP--值FETCHNEXTfromrdevrech_idINTOrdevid,rech_id,slotIFdoneTHENLEAVEr;循环循环；     ENDIF；                                       's's'  ‐‐‐‐ENDIF;//                         tblwhererechargeconfig_id=rech_idlimit1;               INSERTINTO`c_device_rechargeconfig_tbl`(`type`,`style_id`,`is_default`,`dev_type_code`,`is_deleted`,`create_time`,`slot_no`)值​​​​(''4',NULL,'0','0','0','2019-08-1915:59:24',位置);econfig_tbl；INSERTINTO`c_device_rechargeconfig_item_tbl`(`价格`,`商品`,`描述`,`is_d删除`,`create_time`,`价格`,`商品`,`0','2019-08-1915:59:24',新的rech_id）；geconfig_id=new_rech_idwhereid=rdevid;端环；关闭Erdevrech_id;结束;callexcute_job_v340();//执行调用