Alright, I was messing around with some time functions in Mysql and ran acrossed a wierd bug.
After I set starttime to now(), anytime I run another update query against the row starttime changes to a new value. Here is what I did when I noticed the bug.. Does anyone else have a problem doing this? I'm using (mysql Ver 11.18 Distrib 3.23.56, for slackware-linux (i386)) mysql> select * from clientwork; +----+--------+-----------+----------+----------------+----------------+-----------+-------+ | id | active | companyid | worktype | starttime | stoptime | totaltime | notes | +----+--------+-----------+----------+----------------+----------------+-----------+-------+ | 1 | 1 | 1 | 1 | 20030617123435 | 20030617123435 | 95 | | +----+--------+-----------+----------+----------------+----------------+-----------+-------+ 1 row in set (0.00 sec) mysql> UPDATE clientwork SET totaltime=now()-starttime, stoptime=now() where id="1"; Query OK, 1 row affected (0.00 sec) Rows matched: 1 Changed: 1 Warnings: 0 mysql> select * from clientwork; +----+--------+-----------+----------+----------------+----------------+-----------+-------+ | id | active | companyid | worktype | starttime | stoptime | totaltime | notes | +----+--------+-----------+----------+----------------+----------------+-----------+-------+ | 1 | 1 | 1 | 1 | 20030617124037 | 20030617124037 | 602 | | +----+--------+-----------+----------+----------------+----------------+-----------+-------+ 1 row in set (0.00 sec) mysql> UPDATE clientwork SET totaltime=(now()-starttime), stoptime=(now()) where id="1"; Query OK, 1 row affected (0.00 sec) Rows matched: 1 Changed: 1 Warnings: 0 mysql> select * from clientwork; +----+--------+-----------+----------+----------------+----------------+-----------+-------+ | id | active | companyid | worktype | starttime | stoptime | totaltime | notes | +----+--------+-----------+----------+----------------+----------------+-----------+-------+ | 1 | 1 | 1 | 1 | 20030617124122 | 20030617124122 | 85 | | +----+--------+-----------+----------+----------------+----------------+-----------+-------+ 1 row in set (0.00 sec) mysql> UPDATE clientwork SET notes="This is my note" where id="1"; Query OK, 1 row affected (0.00 sec) Rows matched: 1 Changed: 1 Warnings: 0 mysql> select * from clientwork; +----+--------+-----------+----------+----------------+----------------+-----------+-----------------+ | id | active | companyid | worktype | starttime | stoptime | totaltime | notes | +----+--------+-----------+----------+----------------+----------------+-----------+-----------------+ | 1 | 1 | 1 | 1 | 20030617124213 | 20030617124122 | 85 | This is my note | +----+--------+-----------+----------+----------------+----------------+-----------+-----------------+ 1 row in set (0.01 sec) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
