MySQL Timestamps Automatically Update

By default, the TIMESTAMP field in a MySQL table will automatically update to the current timestamp if any of the other fields in the row change. This is extremely useful for situations where you want to track changes such as for an ajax system that wants to fetch any changes…

Read this article