sql - Add value to a column each month in Mysql Data Base

Question

is there a way to update automatically the values of a column in a table in Mysql DB with a predifined value and the update should occur each month.

The situation is that i want to update the column balance in the table employees adding 2.5 days each month to each employee and the total amount of days should be reset each two years for each employee.

Answer 1

Databases don't really work that way. They are meant for storing information. You can write triggers so if you update a row or insert then an event happens but other then that the data doesn't change

Something like this should be handled in the application logic. Creat a cron or other periodic job that will grab rows created on X date and update them