mysql 的job 设置

来源：互联网发布：三网通彩信软件编辑：程序博客网时间：2024/05/29 02:01

创建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; ---设置事件为启动状态

0 0