title: MySQL CURRENT_TIMESTAMP on create and on update
body: <p>I want to define table which will have 2 TIMESTAMP fields, someting like this:</p>
  
  <pre><code>CREATE TABLE `msgs` (
      `id` INT PRIMARY KEY AUTO_INCREMENT,
      `msg` VARCHAR(256),
      `ts_create` TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
      `ts_update` TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
  )
  </code></pre>
  
  <p>How to do this avoiding error:</p>
  
  <pre><code>ERROR 1293 (HY000): Incorrect table definition; there can be only one TIMESTAMP column with CURRENT_TIMESTAMP in DEFAULT or ON UPDATE clause
  </code></pre>
  
  <p>Point is to keep desired behavior of <code>ts_create</code> and <code>ts_update</code> in table schema.</p>