-- 要使定时器起作用 MySQL的常量GLOBAL event_scheduler必须为on或者是1-- 查看是否开启定时器 SHOW VARIABLES LIKE '%sche%'; -- 开启定时器 0:off 1:on SET GLOBAL event_scheduler = ON; -- 开启事件 ALTER EVENT event_test ON COMPLETION PRESERVE ENABLE; -- 关闭事件 ALTER EVENT event_test ON COMPLETION PRESERVE DISABLE; -- MySQL 查看EVENT 相关信息: SELECT * FROM information_schema.EVENTS;-- 创建 EVENT: CREATE EVENT db_name.`event_name` ON SCHEDULE EVERY 1 DAY STARTS concat(date_format(now(),'%Y-%m-%d'),' 00:00:00') ON completion preserve ENABLE DO update tb1 set timtes=10 where times<>10 or times is null;ALTER EVENT db_name.`event_name` ON COMPLETION PRESERVE ENABLE;
SET GLOBAL event_scheduler = ON; ALTER EVENT event_test ON COMPLETION PRESERVE ENABLE; CREATE EVENT db_name.`event_name` ON SCHEDULE EVERY 1 DAY STARTS concat(date_format(now(),'%Y-%m-%d'),' 00:00:00') ON completion preserve ENABLE DO update tb1 set timtes=10 where times<>10 or times is null; 那我是要这么写吗?
我执行SET GLOBAL event_scheduler = ON; 就会出现这个错误啊..#1193 - Unknown system variable 'event_scheduler'
SET GLOBAL event_scheduler = ON;你的MYSQL版本是多少?5.1以上才支持
CREATE EVENT duk_bo.upShare ON SCHEDULE EVERY 1 DAY STARTS concat(date_format(now(),'%Y-%m-%d'),' 00:00:00') ON completion preserve ENABLE DO UPDATE `duk_bo`.`bo_share` SET `times` = '10'; 我这样建的
SHOW VARIABLES LIKE '%sche%'; -- 开启定时器 0:off 1:on
SET GLOBAL event_scheduler = ON; -- 开启事件
ALTER EVENT event_test ON
COMPLETION PRESERVE ENABLE; -- 关闭事件
ALTER EVENT event_test ON
COMPLETION PRESERVE DISABLE;
-- MySQL 查看EVENT 相关信息:
SELECT * FROM information_schema.EVENTS;-- 创建 EVENT:
CREATE EVENT db_name.`event_name`
ON SCHEDULE
EVERY 1 DAY
STARTS concat(date_format(now(),'%Y-%m-%d'),' 00:00:00')
ON completion preserve ENABLE
DO
update tb1 set timtes=10 where times<>10 or times is null;ALTER EVENT db_name.`event_name` ON
COMPLETION PRESERVE ENABLE;
ALTER EVENT event_test ON
COMPLETION PRESERVE ENABLE; CREATE EVENT db_name.`event_name`
ON SCHEDULE
EVERY 1 DAY
STARTS concat(date_format(now(),'%Y-%m-%d'),' 00:00:00')
ON completion preserve ENABLE
DO
update tb1 set timtes=10 where times<>10 or times is null;
那我是要这么写吗?
http://topic.csdn.net/u/20091020/22/c51bb709-6dbc-4fd1-b874-077714ed547e.html
ON SCHEDULE
EVERY 1 DAY
STARTS concat(date_format(now(),'%Y-%m-%d'),' 00:00:00')
ON completion preserve ENABLE
DO
UPDATE `duk_bo`.`bo_share` SET `times` = '10';
我这样建的