I am trying to set up a CRON job that will update a table I have on a daily basis. Here is the code (not showing my username and password) I have currently in my Command line: mysql -u username -p password -D dbname -e “update headtail set spenddate = date_add(spenddate, INTERVAL 1 DAY);” I set the hour and the minute for it to run once each day.
Read this article:
CRON Help needed