In my "Dues_Date" column I have "2012-10-01" which is the time the dues must be paid for the coming term.
I want that date to update itself, if possible, to "2013-10-01" on precisely the original dues date above.
Can mySql do this by itself or do I need to write a script for it? In that case, how does the script get run if I'm, let's say, in Jamaica drinking a pina colada at the time?