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
You are absolutely correct.. I did set it to timestamp by mistake!
-//Lucas
On Tue, 17 Jun 2003, Jennifer Goodie wrote:
After I set starttime to now(), anytime I run another update query against
the row starttime changes to a new value.
If starttime is the timestamp data type, and the
On 17 Jun 2003 at 14:05, Lucas Heuman wrote:
After I set starttime to now(), anytime I run another update query
against the row starttime changes to a new value.
You don't give the structure of your table, but it appears that
you're using a TIMESTAMP column, which has automatic updating by
PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Tuesday, 17 June, 2003 14:05
Subject: Now() and time function bug??
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
After I set starttime to now(), anytime I run another update query against
the row starttime changes to a new value.
If starttime is the timestamp data type, and the first timestamp in the row,
it will automatically update every time you update the row. This is not a
bug, it is expected