title: How do I alter a mysql table column defaults?
body: <p>I have a table with a column of type <code>timestamp</code> which defaults <code>current_timestamp</code> and updates to <code>current_timestamp</code> on every update.</p>
  
  <p>I want to remove the "on update" feature on this column.  How do I write the alter statement?</p>
  
  <p>I tried the following:  </p>
  
  <pre><code>ALTER TABLE mytable alter column time  set DEFAULT now();
  </code></pre>
  
  <p>but this didn't work.</p>