数据库添加数据时，主键字段报错：Field 'mid' doesn't have a default value

简介

在使用ORM框架(Mybatis.JPA…)添加数据时,报错:Field ‘mid’ doesn’t have a default value,这就很奇怪了,因为 mid是数据表的主键,为什么会这样呢?搜了一下网上的说法,莫过于这三种:

1、打开mysql安装目录找到my.ini文件，查找

sql-mode=“STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_
SUBSTITUTION”
修改为
sql-mode=“NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION”

然后重启MYSQL

2、MySQL 5 uses a strict mode which needs to be disabled.

In Windows, Goto Start–>Programs–>MySQL->MySQL Instance Config Wizard. Follow through the Reconfigure Instance option–>Detailed Configuration–>Continue Next a few screens. At the bottom under Enable TCP/IP option there is ‘Enable Strict Mode’. Deslect this option (no tick). Save changes and MySQL will restart.

3、那就可能是你的数据库字段设置有问题.

看看是不是主键只设置了主键,非空,自增有没有选中!!!