MySQL regularly performs task-related issues

Create a new event in the event SQLyog a database and write the code:

DELIMITER $ $ALTER definer= ' root ' @ '% ' EVENT ' 0 ' on SCHEDULE every HOUR starts ' 2018-04-18 00:00:00 ' ENDS ' 2028-12-31 00: 00:00 ' On completion no PRESERVE ENABLE do BEGIN    //do somethingend$ $DELIMITER;

The specific execution is written according to the specific needs, and the last on completion not preserve indicates that the event expires and is no longer retained.

Use the following code to query whether the current MySQL is allowed to execute events:

SHOW VARIABLES like ' Event_scheduler ';

query results can be performed as follows:

If the value is off, execute the following code to open:

SET GLOBAL event_scheduler = 1;

Note: Restarting MySQL will turn this value off

MySQL regularly performs task-related issues