如何修复MySQL的虚假1292'不正确的日期值'错误？ [重复]

Question

This question already has an answer here:

• MySQL ALTER TABLE add column: error at another column 2 answers
• Error in mysql when setting default value for DATE or DATETIME 11 answers

I get the error when trying to add a text column to an existing MySQL table.

The syntax I am using is:

ALTER TABLE tbl_user ADD COLUMN vBio TEXT AFTER vFirstName;

How can I alter the SQL syntax to get rid of this error?

1292 - Incorrect date value ’0000-00-00’ for column ‘dDob’ at row 4

</div>