MySQL ALTER TABLE add column: error at another column
<p>ok, i have <code>people</code> table and try run sql-script with the next command:</p>

<pre><code>ALTER TABLE `people`
    ADD COLUMN `name_spelling`
    VARCHAR(255) NULL DEFAULT NULL
    AFTER `last_name`;
</code></pre>

<p>Then I'll get a error:</p>

<pre><code>[22001][1292] Data truncation: Incorrect date value:
'0000-00-00' for column 'birth_date' at row 35
</code></pre>

<p>At this row <code>birth_date</code> is <code>NULL</code>, but if I try set some date like <code>2016-05-05</code> at this column and row and than set <code>NULL</code> back -- all works is correct at this row, but get error on some next <code>null</code> date.</p>

<p>In addition, not all <code>null</code> date values return error.</p>