56,687
社区成员
发帖
与我相关
我的任务
分享
mysql> show variables like '%event%';
+-----------------+-------+
| Variable_name | Value |
+-----------------+-------+
| event_scheduler | ON |
+-----------------+-------+
1 row in set (0.00 sec)
mysql>
--任务脚本如下:
drop event if exists e_Set;
CREATE EVENT e_Set
ON SCHEDULE EVERY 1 day STARTS '2010-11-15 23:59:59' DO
begin
INSERT INTO EVENT_1 VALUES(NOW());
end;
-- 或者试试看吧,你设置23点,人家不是要等到晚上23点再执行啊。
drop event if exists e_Set;
CREATE EVENT e_Set
ON SCHEDULE EVERY 1 day STARTS '2010-11-15 00:00:00' DO
begin
INSERT INTO EVENT_1 VALUES(NOW());
end;
drop event if exists e_Set;
CREATE EVENT e_Set
ON SCHEDULE EVERY 86400 SECOND STARTS '2010-11-15 00:00:00' DO
begin
INSERT INTO EVENT_1 VALUES(NOW());
end;