Helpful Information
 
 
Category: MySQL
Firing off SQL via Cron

A newbie here...

Can anyone point me to the basics of how firing off a sql statement can be done automatically by CRON on a unix box?

Essentially I want to have a sql sript that clears daily totals in a table every night at 00:01 am -- I understand the script part... but I don't know HOW that happens with Cron

Thanks...

You can write an sql script then run it using crontab:

http://www.dbaoncall.net/references/ht_use_crontab.html










privacy (GDPR)