George/Rick, a quick addition. It is not clear from the question: do you want to have the timestamp updated, or do you want to leave it be?
RTFM: 6.2.2.2 The DATETIME, DATE, and TIMESTAMP Types ... 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. Automatic updating of the first TIMESTAMP column occurs under any of the following conditions: The column is not specified explicitly in an INSERT or LOAD DATA INFILE statement. The column is not specified explicitly in an UPDATE statement and some other column changes value. (Note that an UPDATE that sets a column to the value it already has will not cause the TIMESTAMP column to be updated, because if you set a column to its current value, MySQL ignores the update for efficiency.) You explicitly set the TIMESTAMP column to NULL. If you want to retain the original value, then you need to use the opposite of clause 2! Regards, =dn > timestamp is automatically updated > > If one uses the timestamp data type for a column inside a table, when > executing an update query on said table on a spesific record, will the > timestamp column be updated as well or will it retain its first value? --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
