Mysql makes a stored procedure scheduled job code _ MySQL

Mysql allows bitsCN. com1 code for a scheduled job in a stored procedure. create a database test1 in mysql.

Statement: create database test1

2. create a table examinfo

Create table examinfo (
Id int auto_increment not null,
Endtime datetime,
Primary key (id)
);

3. Insert data:

Insert into examinfo values ('1', '2017-4-23 23:26:50 ');

4. create a stored procedure test

Create procedure test ()
BEGIN
Update examinfo SET endtime = now () WHERE id = 1;
END;

5. create event e_test

Create event if not exists e_test
On schedule every 30 second
On completion preserve
Do call test ();


6. check whether the event is enabled: show variables like '% sche % ';
Enable the event plan: set global event_scheduler = 1;
Close event task: alter event e_test on completion preserve disable;
Account Opening event task: alter event e_test on completion preserve enable;

7. run the query result to display the desired result.

The result is as follows:
Raw data:

Data after a period of query:
BitsCN.com