Automatic table update

[vjayis]

hi

i have an database in which i need to update a status filed of an table with the date.

i,e those datas which gets expired are to be updated..

so need to run a command in mysql by default.,

any ideas??

regards
vijay

[Atli]

Hi.

So you need to automatically run a command at some set interval?

If you are using MySQL 5.1.6 (or later), you can use the Event Scheduler. (See the link for details on that).

However, if you are using an earlier version of MySQL, then there is no internal mechanism to schedule timed commands.

You would have to use your OSs event scheduler to set something like this up.
That would be crontab for Unix/Linux, or the Windows Task Scheduler on Windows.