On 26 Mar 2003 at 9:23, Alejandro Paz wrote: > As you can see the colum `b' is updated, too. > Note, you have to insert a delay of almost 1 second > between the first select > and the update, because the column `b' takes the > current time!. > > Only happens with timestamp columns not with datetime > ones.
You seem to be surprised that b is updated. Have you read the documentation for TIMESTAMP? | The TIMESTAMP column type provides a type that you can use to | automatically mark INSERT or UPDATE operations with the current | date and time. If you have multiple TIMESTAMP columns, only the | first one is updated automatically. [explanation continues] http://www.mysql.com/doc/en/DATETIME.html The strange thing about your example is not the updating of b but the odd value assigned to c, which seems to be different from NOW(), but you say nothing about that. -- Keith C. Ivey <[EMAIL PROTECTED]> Tobacco Documents Online http://tobaccodocuments.org Phone 202-667-6653 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
