Run query overnight

[Jared]

Hi,

I would like to ..

UPDATE TABLE1 SET STATE = A WHERE OCCUPIED = Y

everynight

[No bother]

Jared wrote:

Hi,

I would like to ..

UPDATE TABLE1 SET STATE = A WHERE OCCUPIED = Y

everynight

You basically have two choices. One is to write a program/script
outside of mysql that will run either as a cron job or scheduled task,
depending on your OS. The other is to use the 5.1 series which has
scheduled events. The documentation for that is at
http://dev.mysql.com/doc/refman/5.1/en/events.html . I have not used
this yet, but others here might be able to help you with that. However,
the instructions seem pretty straight-forward.