Does MySql have a function for this? Or must I use Php?

[Michdd]

I want something that will flush a certain field in my database every 24 hours. Is there a way to set MySql to do this like when making the field? Or would I have to use Php? Either way, can someone help me do this?

[trq]

Neither PHP or MySql are going to be much help. You need to use your OS's scheduler. Linux uses cron, windows, something else.

[Michdd]

Neither PHP or MySql are going to be much help. You need to use your OS's scheduler. Linux uses cron, windows, something else.

By using Cron you mean setting cron on a php script?

[Stooney]

Neither PHP or MySql are going to be much help. You need to use your OS's scheduler. Linux uses cron, windows, something else.

By using Cron you mean setting cron on a php script?

 

He meant either that or the low-calorie CRON-diet http://en.wikipedia.org/wiki/CRON-diet

ya never know...

[trq]

Neither PHP or MySql are going to be much help. You need to use your OS's scheduler. Linux uses cron, windows, something else.

By using Cron you mean setting cron on a php script?

 

Cron can execute scripts, yes (wether they be php or whatever doesn't matter). It is the program in charge of executing commands at a given interval on Linux.

[Michdd]

Well, what would be the MySql for wiping 1 field for all rows in the table?

[trq]

UPDATE tbl SET fld = ""