Only the first TIMESTAMP field gets updated when an updat to a record is made, so if you want to maintain the time a record was created, and when it was updated, use two timestamp fields, the first field will be the time updated, but to do this you must initialize the second timestamp field with NOW() when the record is created.
John On Friday 15 February 2002 14:20, George Labuschagne wrote: > Hi all, > > 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? > > Thanks for any info in advance, > > George > mysql, query, sql > > --------------------------------------------------------------------- > 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 --------------------------------------------------------------------- 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