php 写 mysql 事件_使用php的Mysql事件错误

创建活动：

drop event if exists `myevent21222`;

DELIMITER |

CREATE EVENT myevent21222

ON SCHEDULE EVERY 5 MINUTE STARTS '2016-01-01 00:00:00'

ON COMPLETION PRESERVE

DO

BEGIN

UPDATE `team` SET `reg` = '0' WHERE `id` = '1';

END |

# MySQL lieferte ein leeres Resultat zurück (d.h. null Datens?tze).

DELIMITER ;

打开事件处理程序：

SET GLOBAL event_scheduler = ON; -- turn her on and confirm below

确认它已开启：

show variables where variable_name='event_scheduler';

查看活动信息：

show events from so_gibberish2; -- note so_gibberish2 is my database name

– 显然使用上面的数据库名称

禁用或启用它：

ALTER EVENT myevent21222 disable;

ALTER EVENT myevent21222 enable;