faqts : Computers : Databases : MySQL : Tips and Tricks

+ Search
Add Entry AlertManage Folder Edit Entry Add page to http://del.icio.us/
Did You Find This Entry Useful?

13 of 35 people (37%) answered Yes
Recently 5 of 10 people (50%) answered Yes

Entry

I need a field in my table to be updated every day at midnight, if mysql doesnot support triggers, how can i accomplish this with a minimum of fuss?

May 18th, 2000 02:10
Henrik Hansen, Jeff Eidsness,


If you run a unix based system you can setup a cron job to use either 
php or perl to get the info from the databse at a certain time of the 
day.