sql_mode:STRICT_TRANS_TABLES引起的报错

mysql 报错：

1364, Field 'template_content' doesn't have a default value

 

字段定义

`template_content` text NOT NULL COMMENT '分级发布模板内容'

 

sql_mode: 

mysql> select @@sql_mode;
+-----------------------------------------------------------------------------------------------------------------------+
| @@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 |
+-----------------------------------------------------------------------------------------------------------------------+

 

 

修改sql_mode 并重启服务 去掉  STRICT_TRANS_TABLES

## 修改mysql.cnf
## 维持sql_mode现有设置，去掉STRICT_TRANS_TABLES
cat /etc/my.cnf

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"


## 重启mysqld
service mysqld restart

Stopping mysqld:                                           [  OK  ]
Starting mysqld:                                           [  OK  ]