Run query overnight

Hi,

I would like to ..

UPDATE TABLE1 SET STATE = A WHERE OCCUPIED = Y

everynight

Re: Run query overnight

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.