Advertisement
Guest User

Untitled

a guest
Jun 25th, 2019
66
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.22 KB | None | 0 0
  1. //data is the name if table
  2. //wanna update VALUE column.
  3. //TIME column carries the time of data
  4. BEGIN
  5. UPDATE data SET data.VALUE = 0 WHERE data.TIME <= date_sub(NOW(), interval 3 MINUTE) and data.VALUE = 2;
  6.  
  7. END
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement