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.
See Question&Answers more detail:os