title: MySQL create time and update time timestamp
body: <p>I am creating some tables where I want to store the time when a record was created and when it was last updated. I thought I could have two timestamp fields where one would have the value <code>CURRENT_TIMESTAMP</code> and the other would have <code>CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP</code>. But I guess I can't do this because you can have only 1 timestamp field with a default value in a table?</p>
  
  <p>How would you recommend I get and store the two times? Thanks!</p>