Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- //data is the name if table
- //wanna update VALUE column.
- //TIME column carries the time of data
- BEGIN
- UPDATE data SET data.VALUE = 0 WHERE data.TIME <= date_sub(NOW(), interval 3 MINUTE) and data.VALUE = 2;
- END
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement