您可以使用MySQL的事件调度程序

You can use MySQL's event scheduler

CREATE EVENT update_status ON SCHEDULE EVERY 1 DAY STARTS '2013-11-02 00:00:00' DO
  UPDATE your_table
  SET    x = 0

为了使事件调度程序运行，可以将其添加到my.cnf ：

In order to make the event scheduler run you can add this in my.cnf:

[mysqld]
...
event_scheduler=ON

阅读这个更多信息 http://dev.mysql.com/doc/refman/5.1/en/create-event.html