数据库添加数据时,主键字段报错: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、那就可能是你的数据库字段设置有问题.
看看是不是主键只设置了主键,非空,自增有没有选中!!!