title: What is the best way to set up last-modified and date-record-added fields?
body: <p>Hi I would like to set and forget two fields for tracking the date the record was added and also the date the record was last modified in a mySQL database.</p>
  
  <p>I am using "ON UPDATE CURRENT_TIMESTAMP" and was hoping I would just change UPDATE to INSERT.</p>
  
  <p>No luck however. Can anyone give me the heads up on the best way to achieve this? - preferably inside the database itself.</p>