关于MySQL作业配置:
1.set global event_scheduler=on;
2.创建作业CREATE EVENT [`e_test_insert`] ON SCHEDULE EVERY 1 SECOND DO INSERT INTO atest (`b`) VALUES (CURRENT_TIMESTAMP);
3.设置启动作业:alter event [e_test_insert] ON COMPLETION PRESERVE ENABLE;
4.作业停止:alter event [e_test_insert] ON COMPLETION PRESERVE DISABLE;
1.set global event_scheduler=on;
2.创建作业CREATE EVENT [`e_test_insert`] ON SCHEDULE EVERY 1 SECOND DO INSERT INTO atest (`b`) VALUES (CURRENT_TIMESTAMP);
3.设置启动作业:alter event [e_test_insert] ON COMPLETION PRESERVE ENABLE;
4.作业停止:alter event [e_test_insert] ON COMPLETION PRESERVE DISABLE;