Page 1 of 1

record updated details?

Posted: Fri Oct 27, 2006 10:22 pm
by alex.barylski
Is there a low-level updated timestamp associated with each and every record in a MySQL database? If I wanted to keep track of when a record was last updated, would I have to add a field (last_updated)???

Posted: Fri Oct 27, 2006 10:31 pm
by feyd
In MySQL, the TIMESTAMP type automatically updates when the record is altered unless that field itself was updated (explicitly) during the query.