Monday, February 1, 2010

[Level 2] MySQL Schedule Event

If you want to use MySQL scheduling,
you can create event for this purpose.
 
ex. 
CREATE EVENT e
 ON SCHEDULE EVERY 1 MONTH
   STARTS TIMESTAMP '2010-01-01 00:00:00'
   ENDS TIMESTAMP '2010-12-31 23:59:59'
 DO DELETE FROM 'xxxxx';  



Wish this helps.

regards,
Stanley Huang