mysql job 运行时间设置_mysql 的job 设置

创建event Create event ***

On schedule

Every 5 minute

Starts now()

Do

Begin

Call proc();

End

或者不想用存储过程的，可以直接写

create event e_1 on schedule every 1 second do

insert into test3.test_2 select * from test3.test_1

但是开始和停止job 都要这样控制

--- start job

set global event_scheduler = 1;

--- stop job

set global event_scheduler = 0

---查看job

show events;

select * from information_schema.events

在某时间段里每秒执行

---先清空表2

truncate table test_2;

set global event_scheduler = 0

create  event e_2 on schedule every 1  second  STARTS '2010-08-12 16:29:33' ENDS  DATE_ADD('2010-08-12 16:29:33',INTERVAL 1 SECOND) do

insert into test3.test_2 select * from test3.test_1

set global event_scheduler = 1

set global event_scheduler = 0

show variables like  'event_scheduler';  ---查看事件状态 SET GLOBAL event_scheduler = 1;  ---设置事件为启动状态