MYSQL:ERROR: Field '***' doesn't have a default value
来源:互联网 发布:修真的程序员txt下载 编辑:程序博客网 时间:2024/05/21 11:12
在MySQL建表时
ERROR: Field ‘gruopId’ doesn’t have a default value
在MySQL 5.0.2之后对数据输入进行了强制性的加严处理,并且保留了以前的MySQL对非法或不当值并不严厉的行为,MySQL默认是对数据进行加严处理,但你可以为不良值选择更传统的处理方法,从而使得服务器能够拒绝并放弃出现不良值的语句。
解决办法
一
打开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
二
查看你的数据库,定义的时候是不是把主键生成方式设置为int的,但是没有设置为自增的!!或者数据定义的时候设置一个默认值就可以了。
阅读全文
0 0
- MYSQL:ERROR: Field '***' doesn't have a default value
- ERROR: Field 'scId' doesn't have a default value
- Hibernate error: Field 'firmwareId' doesn't have a default value
- Mysql Field * doesn't have a default value解决方法
- Mysql Field * doesn't have a default value解决方法hibernate
- Mysql Field * doesn't have a default value解决方法
- Mysql Field * doesn't have a default value
- Mysql Field * doesn't have a default value解决方法
- MySQL之Field 'email' doesn't have a default value
- Field '***' doesn't have a default value:mysql
- MySQL中出现Field ' ' doesn't have a default value
- Mysql出现Field * doesn't have a default value解决办法
- Mysql Field * doesn't have a default value解决方法
- Mysql出现Field * doesn't have a default value解决办法
- mysql 错误:Field '字段' doesn't have a default value
- Field Doesn't Have a Default Value
- MySQL添加新用户 出现mysql]ERROR 1364 (HY000): Field 'ssl_cipher' doesn't have a default value
- mysql]ERROR 1364 (HY000): Field 'ssl_cipher' doesn't have a default value
- RxSwift
- bzoj4926 皮皮妖的递推
- Spring中PropertyPlaceholderConfigurer类载入外部配置
- Redis和Memcache对比及选择
- shell 学习
- MYSQL:ERROR: Field '***' doesn't have a default value
- Spring任务调度<task:scheduled-tasks>【含cron参数详解】
- 通过旋转候选框实现任意方向的场景文本检测
- Deep learning系列(七)激活函数
- 【PHP】富文本HTML过滤器:HTMLPurifier使用教程(防止XSS)
- 纯css设置选项卡
- CSS选择器
- $ionicNavBarDelegate的使用
- Java类加载器 ClassLoader