Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- mysql> UPDATE `values` SET `usage` = 123456789 WHERE `user` = 2 AND `category` = 1 AND `date` = '2009-03-29 02:45:00';
- Query OK, 1 ROW affected (0.26 sec)
- ROWS matched: 1 Changed: 1 Warnings: 0
- mysql> SELECT * FROM `values` WHERE `usage` = 123456789
- -> ;
- +------+----------+----------+---------------------+--------------+-----------+--------+
- | USER | meter | category | DATE | meterreading | usage | STATUS |
- +------+----------+----------+---------------------+--------------+-----------+--------+
- | 2 | 38881059 | 1 | 2009-03-29 02:45:00 | 1746.04 | 123456789 | 0 |
- +------+----------+----------+---------------------+--------------+-----------+--------+
- 1 ROW IN SET (1.75 sec)
- mysql> SELECT @@global.time_zone, @@SESSION.time_zone;
- +--------------------+---------------------+
- | @@global.time_zone | @@SESSION.time_zone |
- +--------------------+---------------------+
- | SYSTEM | SYSTEM |
- +--------------------+---------------------+
- 1 ROW IN SET (0.00 sec)
- mysql> UPDATE `values` SET `usage` = NULL WHERE `user` = 2 AND `category` = 1 AND `date` = '2009-03-29 02:45:00';
- Query OK, 1 ROW affected (0.28 sec)
- ROWS matched: 1 Changed: 1 Warnings: 0
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement