title: How to set a timer in mysql
body: <p>Suppose the current date is 20141110 10:00pm ,
  I would like to let mysql to update a field  and then dump few fields into a file while the date is 20141201 10:00pm</p>
  
  <p>how to implement it?</p>
  
  <p>What I know is to use event, but this seems to be used under some interval time. like every few hours/days/weeks to make the event happen.</p>