错误号:1364 错误信息:Field 'platId' doesn't have a default value

原创 2015年07月10日 22:35:08

1. 错误描述

错误号:1364
错误信息:Field 'platId' doesn't have a default value


insert into `use`.`t_platform_scale` () values ()

2.错误原因

由于在建表时,给platId一个not null限制,而且没有给默认值,在插入数据时未插入,导致报错

3.解决办法

(1)修改platId可以为null
(2)插入数据时一定要插入platId

版权声明:本文为博主原创文章,未经博主允许不得转载。 举报

相关文章推荐

Field 'id' doesn't have a default value问题解决方法

Field 'id' doesn't have a default value问题解决方法

[mysql]ERROR 1364 (HY000): Field 'ssl_cipher' doesn't have a default value

转载自:http://www.cnblogs.com/joeblackzqq/p/4526589.html From: http://m.blog.csdn.net/blog/langkez...

精选:深入理解 Docker 内部原理及网络配置

网络绝对是任何系统的核心,对于容器而言也是如此。Docker 作为目前最火的轻量级容器技术,有很多令人称道的功能,如 Docker 的镜像管理。然而,Docker的网络一直以来都比较薄弱,所以我们有必要深入了解Docker的网络知识,以满足更高的网络需求。

Field 'id' doesn't have a default value 原因

Field 'id' doesn't have a default value昨晚做项目的时候遇到一个问题,在测试数据存储的时候老是报Field 'id' doesn't have a default...

Caused by: java.sql.SQLException: Field 'id' doesn't have a default value

1、错误描述 org.hibernate.exception.GenericJDBCException: error executing work at org.hibernate.exceptio...

ERROR: Field 'scId' doesn't have a default value

**问题标签:** hibernate、@ManyToMany 、主键 **抛出异常:ERROR: Field 'scId' doesn't have a default value**

Caused by: java.sql.SQLException: Field 'id' doesn't have a default value

org.hibernate.exception.GenericJDBCException: could not insert: [com.green.vo.Login] at org.hiberna...

Caused by: java.sql.SQLException: Field 'stu_id' doesn't have a default value

1、错误描述### Cause: java.sql.SQLException: Field 'stu_id' doesn't have a default value ; SQL []; Field ...
返回顶部
收藏助手
不良信息举报
您举报文章:深度学习:神经网络中的前向传播和反向传播算法推导
举报原因:
原因补充:

(最多只允许输入30个字)