본문 바로가기

mysql

invalid default value for datetime

 

 

https://stackoverflow.com/questions/9192027/invalid-default-value-for-create-date-timestamp-field

 

Invalid default value for 'create_date' timestamp field

I have the following sql create statement mysql> CREATE TABLE IF NOT EXISTS `erp`.`je_menus` ( -> `id` INT(11) NOT NULL AUTO_INCREMENT , -> `name` VARCHAR(100) NOT NULL , ...

stackoverflow.com

 

 

 

SET SQL_MODE='ALLOW_INVALID_DATES';