title: Alter Table fails because a row has incorrect data - Incorrect datetime value: '0000-00-00 00:00:00'
body: <p>I am updating the current user table with the following statement:</p>
  
  <pre><code>`ALTER TABLE  `users` ADD  `title` VARCHAR( 5 ) NULL DEFAULT NULL AFTER  `surname` ;`
  </code></pre>
  
  <p>Which returns the following error:</p>
  
  <p><code>#1292 - Incorrect datetime value: '0000-00-00 00:00:00' for column 'created_at' at row 1</code></p>
  
  <p>Created_at column structure is:</p>
  
  <p><code>created_at datetime NOT NULL</code></p>
  
  <p>Not sure why the data is invalid - could it be related to MySQL versions (from 5.5.43 into 5.1.73)?</p>
  
  <p>The fix I have at the moment is to update the datetime value before the ALTER TABLE statement:</p>
  
  <pre><code>UPDATE `users` SET `created_at`='2014-01-01 00:00:00' WHERE `created_at`='0000-00-00 00:00:00';
  </code></pre>
  
  <p>Is this a reasonable workaround?</p>