Advertisement
Guest User

Untitled

a guest
Jun 27th, 2017
465
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 1.22 KB | None | 0 0
  1. mysql> UPDATE `values` SET `usage` = 123456789 WHERE `user` = 2 AND `category` = 1 AND `date` = '2009-03-29 02:45:00';
  2. Query OK, 1 ROW affected (0.26 sec)
  3. ROWS matched: 1  Changed: 1  Warnings: 0
  4.  
  5. mysql> SELECT * FROM `values` WHERE `usage` = 123456789
  6.     -> ;
  7. +------+----------+----------+---------------------+--------------+-----------+--------+
  8. | USER | meter    | category | DATE                | meterreading | usage     | STATUS |
  9. +------+----------+----------+---------------------+--------------+-----------+--------+
  10. |    2 | 38881059 |        1 | 2009-03-29 02:45:00 |      1746.04 | 123456789 | 0      |
  11. +------+----------+----------+---------------------+--------------+-----------+--------+
  12. 1 ROW IN SET (1.75 sec)
  13.  
  14. mysql> SELECT @@global.time_zone, @@SESSION.time_zone;
  15. +--------------------+---------------------+
  16. | @@global.time_zone | @@SESSION.time_zone |
  17. +--------------------+---------------------+
  18. | SYSTEM             | SYSTEM              |
  19. +--------------------+---------------------+
  20. 1 ROW IN SET (0.00 sec)
  21.  
  22. mysql> UPDATE `values` SET `usage` = NULL WHERE `user` = 2 AND `category` = 1 AND `date` = '2009-03-29 02:45:00';
  23. Query OK, 1 ROW affected (0.28 sec)
  24. ROWS matched: 1  Changed: 1  Warnings: 0
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement