MySQL Create a scheduled storage task

Implementation of database scheduling tasks through MySQL event timed execution

The Timer event syntax for creating MySQL is

CREATE  EVENT ' test_event ' on SCHEDULE every 5 SECOND starts now () on completion not PRESERVE Enabledo call ' Myprocedure '

On schedule every 5 second means to execute every 5 seconds

Starts now () means starting from the present

On completion not preserve enable means that the event will be automatically deleted when the event expires

Do SQL statement indicates the execution of specific content

MySQL Create a scheduled storage task