How to make my database periodically update its table?
Suppose that each month I have to update the "total_money" attribute of the table "worker", for example the first month this attribute will be 1000, the next month the attribute will be 2000 (1000 prev. month + 1000 current month).
How can I do this AUTOMATICALLY?
(The database can interact with PHP scripts, so also a PHP script would be useful (but idk how could it work automatically)).
Be the first to answer this question.