[MySQL] Setting date data type default value NULL instead of 0000-00-00

In MySQL date data type, if the date value is not provided while inserting record, ‘0000-00-00’ will be added as

If you want to insert empty value for date field and do not want it saved as 0000-00-00, make your date firled NULL as default and do one of the following.

Either specify the data as NULL, or omit the field from the insert query, e.g.:

INSERT INTO table SET name='PI Media';

OR 

INSERT INTO table (name, date) VALUES ('PI Media', NULL);

Hope that helps.

Cheers.