Code running every 24hours that updates data in database

Asked Jul 05 '16 at 17:17

Active May 25 '20 at 02:11

Viewed 91 times

I want to ask how can I do something like this. I want every 24 hours to update the value in the table in the database and I don´t know how it can be done.

I need to it to be automatic, that means I won't be doing anything it will just do it on itself when its time

I am using MySQL database with PHP version is 7.0

So how it can be done? I don't need code (but I don't mind) but the mechanism, I want just description can I put some code into the database and it will do it automatically or run some file on server or?

edited May 25 '20 at 02:11

brew

asked Jul 05 '16 at 17:17

Filip Bartoš

3

What operating system. Linux systems can use cron jobs, Windows can use scheduled tasks – dbmitch Jul 05 '16 at 17:18
Depending on the database, it may support scheduled jobs. such as http://dev.mysql.com/doc/refman/5.7/en/events-overview.html for mysql – xQbert Jul 05 '16 at 17:20
1

https://www.sitepoint.com/how-to-create-mysql-events/ – Bryan Dellinger Jul 05 '16 at 17:21
Thanks all for help, I think I will use mysql events. – Filip Bartoš Jul 05 '16 at 17:23
Just change your interval accordingly [1](http://stackoverflow.com/a/32508935) and [2](http://stackoverflow.com/a/37901661) – Drew Jul 06 '16 at 05:57

Code running every 24hours that updates data in database

0 Answers0