> 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]