record updated details?

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
alex.barylski
DevNet Evangelist
Posts: 6267
Joined: Tue Dec 21, 2004 5:00 pm
Location: Winnipeg

record updated details?

Post 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)???
User avatar
feyd
Neighborhood Spidermoddy
Posts: 31559
Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA

Post by feyd »

In MySQL, the TIMESTAMP type automatically updates when the record is altered unless that field itself was updated (explicitly) during the query.
Post Reply