Navicat for MySQL set timed tasks (events)

1. Query interface input command, check whether the scheduled task is open, does not start off:show variables like '%event_scheduler% '; 2. Query interface Input command, open timed task: Set global Event_scheduler =1 (then use show variables like '%sche% '; Can be viewed as on) 3. The new function, named Update_time, is the UPDATE statement 4. Create a new event, define a function that says call Update_time---just defined, plan to select every 1 days (updated daily), Starts is the scheduled task start execution time

Navicat for MySQL set timed tasks (events)