CREATE DEFINER=`gzy`@`%` PROCEDURE `delLastMonth`()

BEGIN

DECLARE lastmonth int;

SET lastmonth = DATE_FORMAT(date_sub(curdate(),interval 1 MONTH),'%Y%m');

DELETE FROM wysytask.user_sign WHERE `month`=lastmonth;

DELETE FROM wysytask.user_resign WHERE `month`=lastmonth;

END

CREATE DEFINER=`gzy`@`%` EVENT `delLastMonth` ON SCHEDULE EVERY 1 MONTH STARTS '2016-08-01 00:00:05' ON COMPLETION NOT PRESERVE ENABLE DO CALL delLastMonth