Use things + events to execute stored procedures in MySQL stored procedure

(1) Stored procedures

DROP PROCEDURE IF EXISTSproc_test;CREATE  PROCEDUREproc_test ()BEGIN  DECLARET_errorINTEGER DEFAULT 0; DECLARE CONTINUEHANDLER forSQLEXCEPTIONSETT_error=1; STARTTRANSACTION; Insert  intoScore_record_bak (OpenID, nickname, city_id, City_name, Grid_number, Score_type, Channel_manager_score, Channel_ma Nager_remark, Railcom_support_score, Railcom_support_remark, Manager_support_score, Manager_support_remark, Insert_ Time, Weixin_accountid)SelectOpenID, nickname, city_id, City_name, Grid_number, Score_type, Channel_manager_score, Channel_manager_remark, rail Com_support_score, Railcom_support_remark, Manager_support_score, Manager_support_remark, Insert_time, Weixin_ AccountId fromScore_record; DELETE  fromDezhou_score_record; IFT_error= 1  Then          ROLLBACK; ELSE          COMMIT; END IF; END;

(2) Event

Timed execution of stored procedures
CREATE EVENT if not exists E_dezhou_score_record
On SCHEDULE every 1 MONTH starts ' 2017-05-01 00:00:00 '
On completion not PRESERVE ENABLE
Do call Proc_test ();

Use things + events to execute stored procedures in MySQL stored procedure