Mysql built-in scheduled task Learning

Mysql built-in scheduled task learning Java code www.2cto.com show version (); // version later than 5.1 show variables like '% event %'; event_scheduler | off set global event_scheduler = ON; // enable the scheduled task SELECT * FROM mysql. event \ G // view the currently running scheduled task use test // first CREATE the test database create table aaa (t TIMESTAMP); create event e_test_insert on schedule every 1 second do insert into test. aaa VALUES (CURRENT_TIMESTAMP); after 5 days, clear the table create event e_test on schedule at CURRENT_TIMESTAMP + INTERVAL 5 day do truncate table test. aaa; regularly clear the table create event e_test on schedule every 1 day do truncate table test. aaa; drop event e_test_insert;