CREATE EVENT `tablets_cache_update` ON SCHEDULE EVERY 13 MINUTE DO begin update `aa` set `a1`=10 where `a1`>=50; end;
SET GLOBAL event_scheduler = 1; CREATE EVENT `tablets_cache_update` ON SCHEDULE EVERY 13 MINUTE DO begin update `aa` set `a1`=10 where `a1`>=50; end;
你的这个语句本身没有语法上的任何问题。 楼主为什么认为它不对呢?没有定期执行?检查一下event_scheduler是否已经激活EVENT计划。把它设置为ONmysql> show variables like 'event_scheduler'; +-----------------+-------+ | Variable_name | Value | +-----------------+-------+ | event_scheduler | OFF | +-----------------+-------+ 1 row in set (0.00 sec)mysql> mysql> set GLOBAL event_scheduler=on; Query OK, 0 rows affected (0.00 sec)mysql>
update `aa` set `a1`=10 where `a1`>=50;
end;
CREATE EVENT `tablets_cache_update` ON SCHEDULE EVERY 13 MINUTE DO begin
update `aa` set `a1`=10 where `a1`>=50;
end;
+-----------------+-------+
| Variable_name | Value |
+-----------------+-------+
| event_scheduler | OFF |
+-----------------+-------+
1 row in set (0.00 sec)mysql>
mysql> set GLOBAL event_scheduler=on;
Query OK, 0 rows affected (0.00 sec)mysql>
谢谢各位了