Mysql数据库 - 如何让它在23:59每周日更新[关闭]

Question

So i have this project going on and I've been looking into it a bit myself, but nothing I've done so far have worked automatically. What i want is a method of automatically updating my table without having to manually executing the command by loading the site.

Answer 1

make a page as normal php function with whatever you want do update

set cron tab in your server using crontab -e

and then edit the cronjob like this

59 23 * * 0 /var/www/somedirectory/somephpfile.php

cron tab run the code once at sunday 11.59 pm each sunday

description for above code

[Minute] [Hour] [Day] [Month] [Day of week (0 =sunday to 6 =saturday)] [Command]

here is crontab reference