A easy way to do something like that is use a field with date and before
read the table make some update with the now() mysql native function inside
de where restriction
something like
update people set people.status = "logout" where ( now() -
people.timeenter) > 2000
On Dec 6, 2007 6:00 AM, sandesh.s_magdum <sandesh.s_magdum@xxxxxxxxxxx>
wrote:
> I need to set say `status` field of a mysql table to 'N' for suppose 8
> hours. After completing 8 hours the `status` should be set to 'Y' again.
> Is there any technique like mysql triggers or mysql events with which
> I can achieve my requirement?
>
> Thank you in advance!
>
> Have a great day ahead.
>
> Regards
>
> Sandesh.
>
>
>
--
O Blaine - What the developing
/|\ should'nt have been
| thiagomata.blog.com
/ \
[Non-text portions of this message have been removed]
