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
how to implement it?
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.