How to change a datetime or date column in MySQL to default NULL.
Without applying the NO_ZERO_DATE compatibility mode workaround. Also fixes incorrect datetime value: '0000-00-00 00:00:00'.
-
MySQL 5.7 set datetime column to NULL from 0000-00-00 00:00:00
Change an existing datetime or date column in MySQL 5.7 to NULL as default
I have require on my existing website. I need this to be implement this insert query, date field is already in null but it always insert 0000-00-00 format