Field 'id' doesn't have a default value 原因
来源:互联网 发布:软件开发发展前景 编辑:程序博客网 时间:2024/05/16 09:47
Field 'id' doesn't have a default value昨晚做项目的时候遇到一个问题,在测试数据存储的时候老是报Field 'id' doesn't have a default value异常,从网上找了好久,根据各位大虾的说法也测试了好久好久,可就是没发现原因所在,鼓捣了两三个小时的时间,最后总算找到问题所在:原来是我的数据设计的时候,把主键的类型定义为int的,原本想是用自增的方式来的,可是由于自己的粗心,写sql语句的时候没有加上auto_increment,所以在数据存储的时候老是报Field 'id' doesn't have a default value,id根本就没有值啊!!
加上自己从网上找的其他人说的他们遇到这种时候的原因,在这里总结一下:
1、打开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、看看你的数据库定义的时候是不是把主键生成方式设置为int的,但是没有设置为自增的!!或者数据定义的时候设置一个默认值就可以了。
- Field 'id' doesn't have a default value 原因
- Field 'id' doesn't have a default value 原因
- Field 'id' doesn't have a default value 原因
- hibernate:Field 'id' doesn't have a default value 原因
- Field 'id' doesn't have a default value
- Field 'id' doesn't have a default value
- Field 'id' doesn't have a default value
- Field 'id' doesn't have a default value问题解决方法
- Field 'id' doesn't have a default value
- Field 'id' doesn't have a default value
- Field 'id' doesn't have a default value
- hibernate的Field 'id' doesn't have a default value
- hibernate异常 --- Field "id" doesn't have a default value
- Field 'id' doesn't have a default value
- Field 'id' doesn't have a default value
- Field 'id' doesn't have a default value
- Field 'id' doesn't have a default value问题解决方法
- Field 'id' doesn't have a default value问题解决方法
- Android Launcher总体分析
- Access、Sql随机文章
- Uglifyjs压缩工具安装
- 响应式web设计 HTML5+css3实战 学习笔记
- se android 在google nexus 运行(有bug)
- Field 'id' doesn't have a default value 原因
- 合并多个js,css文件的方法
- android联系人信息的存储结构
- Oracle 10g忘记system,sys,sysman密码解决方案
- Linux平台下WebRTC音视频获取(Javascript API) .
- live555的RTCP
- Maven 安装
- 走出软件作坊(笔记)
- cocos2d-x 2.0.3 设置高清模式注意事项(已移除-hd方式)