如果我在mysql中运行我的事件会发生什么？

Question

I have created a small script in mysql and run it. It does create an event but what happens next? DO I still need to call it in php or does it run according to the schedule I declared within the even.

Here's my event

DELIMITER |

CREATE EVENT updatedoggytreat
ON SCHEDULE EVERY 1 MONTH STARTS '2011-07-01 00:00:00'
ON COMPLETION PRESERVE
DO
  BEGIN
    UPDATE animal SET treat = treat + 6, bone = 5 WHERE breed = 'Bulldog' ;
    UPDATE animal SET treat = treat + 3, bone = bone + 4 WHERE breed  = 'small dog';
    UPDATE animal SET treat = treat + 6, bone = 5 WHERE breed = 'mix breed';
    UPDATE animal SET treat = 10, bone = 5 WHERE breed  = 'doberman';
    UPDATE animal SET treat = 15 WHERE breed  = 'sheepdog';
  END |

 DELIMITER ;

Do I still have to call this one in php or does it runs automatically based on the schedule I stated.

Many Thanks.

Answer 1

http://dev.mysql.com/doc/refman/5.1/en/events-overview.html

You do not have to call it manually using anything. They are scheduled events or "temporal triggers".

The SQL instance, that is, the server itself will manage it all. So long as your mysql is running, in accordance to the times that you set and periodicity etc, the event will trigger as you would expect.

You might want to do some research into what happens if it happens to be down at the time the scheduled event is meant to occur - that may be a configuration option.