Invalid default value for 'post_date' ignore this error
if you generated the script from the MySQL workbench.
The following line is generated
SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='TRADITIONAL,ALLOW_INVALID_DATES';
Remove TRADITIONAL from the SQL_MODE, and then the script should work fine
Else, you could set the SQL_MODE as Allow Invalid Dates
SET SQL_MODE='ALLOW_INVALID_DATES';
reference :
https://stackoverflow.com/questions/9192027/invalid-default-value-for-create-date-timestamp-fieldAre there any code examples left?
New code examples in category Other
Relative searches
Invalid default value for 'post_date
date NOT NULL DEFAULT current_timestamp(), 1067
#1067 - Invalid default value for date NOT NULL DEFAULT current_timestamp(),
Invalid default value for field date mysql
mysql Invalid default value for 'scheduled_date_gmt'
add primary key and it said invalid default value for datetime
invalid default value
mysql Invalid default value for
invalid default value for 'scheduled_date_gmt' fix
Invalid default value for 'scheduled_date_gmt' fix
timestamp invalid default value sql error
mysql invalid default value for 'post_date'
invalid default value for
invalid default value for 'post_date'
invalid default value for timestamp
Invalid default value for 'post_date' ignore this error
