title: What does the Alter Table syntax look like for adding a DATETIME column?
body: <p>I can't find what the syntax looks like for adding a DATETIME column to a mysql table when I want to set the default to - example - 2011-01-26 14:30:00</p>
  
  <p>Does anyone know what that syntax looks like?</p>
  
  <p>Here's what I've got</p>
  
  <pre><code>ADD COLUMN new_date DATETIME AFTER preceding_col,
  </code></pre>
  
  <p>Thanks</p>