37,event_Wake,Do Nothing! Only not let Foolish MySQL Sleep! HeiHei!,No Log,2009-08-17 16:59:59
38,event_Wake,Do Nothing! Only not let Foolish MySQL Sleep! HeiHei!,No Log,2009-08-17 17:59:59
39,event_Wake,Do Nothing! Only not let Foolish MySQL Sleep! HeiHei!,No Log,2009-08-17 19:29:35
40,event_Wake,Do Nothing! Only not let Foolish MySQL Sleep! HeiHei!,No Log,2009-08-17 23:29:11
41,event_Wake,Do Nothing! Only not let Foolish MySQL Sleep! HeiHei!,No Log,2009-08-18 03:29:12
43,event_Wake,Do Nothing! Only not let Foolish MySQL Sleep! HeiHei!,No Log,2009-08-18 07:29:11
44,event_Wake,Do Nothing! Only not let Foolish MySQL Sleep! HeiHei!,No Log,2009-08-18 08:04:15
45,event_Wake,Do Nothing! Only not let Foolish MySQL Sleep! HeiHei!,No Log,2009-08-18 08:59:59
46,event_Wake,Do Nothing! Only not let Foolish MySQL Sleep! HeiHei!,No Log,2009-08-18 09:59:59
47,event_Wake,Do Nothing! Only not let Foolish MySQL Sleep! HeiHei!,No Log,2009-08-18 10:59:59
48,event_Wake,Do Nothing! Only not let Foolish MySQL Sleep! HeiHei!,No Log,2009-08-18 11:59:59
49,event_Wake,Do Nothing! Only not let Foolish MySQL Sleep! HeiHei!,No Log,2009-08-18 12:59:59
50,event_Wake,Do Nothing! Only not let Foolish MySQL Sleep! HeiHei!,No Log,2009-08-18 13:59:59这个是我的Event的Log,
哈哈,本来1小时跑一次,
结果到晚上没人类管it,
it 不但不准点,还偷懒,4小时跑一次
38,event_Wake,Do Nothing! Only not let Foolish MySQL Sleep! HeiHei!,No Log,2009-08-17 17:59:59
39,event_Wake,Do Nothing! Only not let Foolish MySQL Sleep! HeiHei!,No Log,2009-08-17 19:29:35
40,event_Wake,Do Nothing! Only not let Foolish MySQL Sleep! HeiHei!,No Log,2009-08-17 23:29:11
41,event_Wake,Do Nothing! Only not let Foolish MySQL Sleep! HeiHei!,No Log,2009-08-18 03:29:12
43,event_Wake,Do Nothing! Only not let Foolish MySQL Sleep! HeiHei!,No Log,2009-08-18 07:29:11
44,event_Wake,Do Nothing! Only not let Foolish MySQL Sleep! HeiHei!,No Log,2009-08-18 08:04:15
45,event_Wake,Do Nothing! Only not let Foolish MySQL Sleep! HeiHei!,No Log,2009-08-18 08:59:59
46,event_Wake,Do Nothing! Only not let Foolish MySQL Sleep! HeiHei!,No Log,2009-08-18 09:59:59
47,event_Wake,Do Nothing! Only not let Foolish MySQL Sleep! HeiHei!,No Log,2009-08-18 10:59:59
48,event_Wake,Do Nothing! Only not let Foolish MySQL Sleep! HeiHei!,No Log,2009-08-18 11:59:59
49,event_Wake,Do Nothing! Only not let Foolish MySQL Sleep! HeiHei!,No Log,2009-08-18 12:59:59
50,event_Wake,Do Nothing! Only not let Foolish MySQL Sleep! HeiHei!,No Log,2009-08-18 13:59:59这个是我的Event的Log,
哈哈,本来1小时跑一次,
结果到晚上没人类管it,
it 不但不准点,还偷懒,4小时跑一次
39,event_Wake,Do Nothing! Only not let Foolish MySQL Sleep! HeiHei!,No Log,2009-08-17 19:29:35
40,event_Wake,Do Nothing! Only not let Foolish MySQL Sleep! HeiHei!,No Log,2009-08-17 23:29:11
41,event_Wake,Do Nothing! Only not let Foolish MySQL Sleep! HeiHei!,No Log,2009-08-18 03:29:12
43,event_Wake,Do Nothing! Only not let Foolish MySQL Sleep! HeiHei!,No Log,2009-08-18 07:29:11
44,event_Wake,Do Nothing! Only not let Foolish MySQL Sleep! HeiHei!,No Log,2009-08-18 08:04:15
这个阶段出问题了 没看到少了42
你这个event怎么弄的 教教我 我也试试!
DELIMITER $$ALTER EVENT `event_Wake` ON SCHEDULE EVERY 1 HOUR STARTS '2009-08-16 23:59:59' ON COMPLETION NOT PRESERVE ENABLE DO BEGIN
/*SET GLOBAL event_scheduler = 1;*/
insert into acorndb_new.sys_event_log
( EVENT_NAME, EVENT_JOB, EVENT_LOG, EVENT_RUN_TIME )
values
( 'event_Wake', 'Do Nothing! Only not let Foolish MySQL Sleep! HeiHei!', 'No Log', now() );
END$$DELIMITER ;
现在告诉你,
在Linux/unix下都是正常的,在windows下面情况不同