Guest User

Untitled

a guest
Dec 12th, 2018
62
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.27 KB | None | 0 0
  1. UPDATE mytable SET
  2. temperature=35,
  3. pressure=122,
  4. installed=NOW(),
  5. status=1
  6. WHERE id=12457
  7.  
  8. UPDATE mytable SET
  9. temperature=35,
  10. pressure=122,
  11. installed=IF(installed IS NULL,NOW(),installed),
  12. status=1
  13. WHERE id=12457
  14.  
  15. UPDATE mytable SET
  16. installed=installed,
  17. WHERE id=12457
Add Comment
Please, Sign In to add comment