mysql 定时任务事件

CREATE EVENT `user_status` ON SCHEDULE EVERY 1 DAY STARTS '2020-07-22 01:00:00' ON COMPLETION PRESERVE ENABLE DO update yoshop_user set status=0 where wxapp_id='888888'

CREATE EVENT `live_main_status` ON SCHEDULE EVERY 1 DAY STARTS '2020-07-22 01:00:00' ON COMPLETION PRESERVE ENABLE DO update yoshop_live_main set status=3 where wxapp_id='888888'