USE wlm212;
CREATE EVENT Myevents
ON SCHEDULE EVERY 7 WEEK STARTS
'2013-07-20 23:45:00'
ON COMPLETION PRESERVE
ENABLE
DO
INSERT INTO ziyuan_fenlei(ziyuan_fenlei.ziyuanfenlei_name) VALUES ('爱情')
写了好几种,这个是其中一个。反正就不执行。哪个高手会啊。我服务器是windows的,那个"里牛客斯"的东西用不了。每周日23点45分,执行一个任务。搞了一天,资料越看越晕。
ON SCHEDULE EVERY 7 DAY starts '2012-07-14 23:45:00'
ON COMPLETION PRESERVE
do
INSERT INTO ziyuan_fenlei(ziyuan_fenlei.ziyuanfenlei_name) VALUES ('爱情');另外开启set global event_scheduler =1;
ON SCHEDULE EVERY 7 DAY starts '2012-07-14 23:45:00'
ON COMPLETION PRESERVE
do
INSERT INTO ziyuan_fenlei(ziyuan_fenlei.ziyuanfenlei_name) VALUES ('爱情'); 另外开启set global event_scheduler =1;应该可以,没有执行?检查一下event_scheduler的值