not null default '' 无法插入 mysql模式_mysql not null 列 设置了default 值 ，代码插入本列为null时报错 - 墨天轮问答...

表：

create_time` timestamp(0) not null DEFAULT CURRENT_TIMESTAMP COMMENT ‘创建时间’,

后端报错：

Column ‘create_time’ cannot be null

; Column ‘create_time’ cannot be null; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Column ‘create_time’ cannot be null, errorLocation：SQLExceptionSubclassTranslator.java:87

sql_mode:

ONLY_FULL_GROUP_BY,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION

mysql-version:5.7.22-log