CODEWITHSUNDEEP
phpmysqldatetimeauto-update
TrungHoang
TrungHoang

Reputation: 15

How to update automatically data when finished day (00:00) in mysql

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?

Upvotes: 0

Views: 606

Answers (1)

Palindromer
Palindromer

Reputation: 994

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.

Upvotes: 1

Related Questions