I have a table where I have a column named
time_stampon update current timestamp).
I have an update trigger which changes the value of state column to
0based on some condition.
I want to set the value of
1after 24 hours of
modify_time, if it is still
I tried below method to test :
CREATE EVENT myevent1 ON SCHEDULE AT current_timestamp + interval 1 minute DO UPDATE test.mytabletable SET state = 0;
This did not doing anything. Is there any alternative method?