i have a table where i have a column named 'state'(int(2)) and 'modify_time' (time_stamp on update current timestamp).
i have an update trigger which changes the value of state column to 0 based on some condition.
3 . i want to set the value of state column to 1 after 24 hours of modify_time , if it still 0 .
4 . i tried below method to test :
CREATE EVENT myevent1 ON SCHEDULE AT current_timestamp + interval 1 minute DO UPDATE test.mytabletable SET state = 0;
but it is not doing any thing.
is there any other alternative method ?