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 first timestamp in the row, > it will automatically update every time you update the row. This is not a > bug, it is expected behavior. Read up on the timestamp data type > (http://www.mysql.com/doc/en/DATETIME.html). If it is a type other than > timestamp (you did not specify), then this could be a bug. > > > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]