title: Is there a MySQL option/feature to track history of changes to records?
body: <p>I've been asked if I can keep track of the changes to the records in a MySQL database. So when a field has been changed, the old vs new is available and the date this took place. Is there a feature or common technique to do this?</p>
  
  <p>If so, I was thinking of doing something like this. Create a table called <code>changes</code>. It would contain the same fields as the <strong>master</strong> table but prefixed with old and new, but only for those fields which were actually changed and a <code>TIMESTAMP</code> for it. It would be indexed with an <code>ID</code>. This way, a <code>SELECT</code> report could be run to show the history of each record. Is this a good method? Thanks!</p>