A brief discussion on MySQL event planning tasks

1. Check whether event is enabled

show variables like '%sche%';
set global event_scheduler =1;

two,

-- Set the time zone and set the event scheduler to ON, or event_scheduler = ON
set time_zone = '+8:00';
set GLOBAL event_scheduler = 1;

-- Set the database base database used or to which this event belongs
use test;

-- If there is a task plan with this name, delete it first
drop event if exist test_update;

-- Set the delimiter to '$$'. The default statement delimiter for MySQL is ';'. This way, the subsequent create to end code will be treated as a single statement for execution.
DELIMITER $$

-- Create a scheduled task, set the first execution time to '2012-11-15 10:00:00', and execute it once a day

-- on schedule every 30 seconds
-- on schedule every day starts timestamp '2012-11-15 10:00:00'

create event test_update
on schedule every day starts timestamp '2012-11-15 10:00:00'
do

-- Start the task to do
begin

-----------------------------------
-- do something Write what your cron job is going to do
-----------------------------------

-- End the scheduled task
end $$

-- Set the statement separator back to ';'
DELIMITER ;

The above is all I have to say about MySQL event planning. I hope it can give you a reference. I also hope that you will support 123WORDPRESS.COM.