如何在mysql中完成日（00:00）时自动更新数据

Question

I am developing a project by PHP and Mysql (PhpMyadmin), so I would like to update data automatically when finished day (00:00) in mysql.

Any ideas?

Answer 1

You have to use MySql-events.

Use below code for executing daily at 00:00:

CREATE EVENT my_event
  ON SCHEDULE
    EVERY 1 DAY
    STARTS '2014-04-30 00:00:00' ON COMPLETION PRESERVE ENABLE 
  DO
    # My query

Use below code for executing only once at 00:00:

CREATE EVENT my_event
    ON SCHEDULE
  AT ('2017-03-14 00:00:00'+ INTERVAL 1 DAY) ON COMPLETION PRESERVE ENABLE 
    DO
  # My query

Also, read the documentation on CREATE EVENT.