特牛网址导航

MYSQL插入报错:SQLSTATE[HY000]: General error: 1364 Field 'xxxxx' doesn't have a default value_general error: 1364 field 'client_id' doesn't have-CSDN博客

网友收藏
  • 链接地址:https://blog.csdn.net/cuilei210/article/details/96442797
  • 链接标题:MYSQL插入报错:SQLSTATE[HY000]: General error: 1364 Field 'xxxxx' doesn't have a default value_general error: 1364 field 'client_id' doesn't have-CSDN博客
  • 所属网站:blog.csdn.net
  • 被收藏次数:2490
文章浏览阅读3.2w次,点赞8次,收藏11次。mysql报错提示:SQLSTATE[HY000]: General error: 1364 Field ‘xxxxx’ doesn’t have a default value这个报错翻译过来就是:xxxxx字段没有默认的数值;也就是说我们没有为其分配数值,而表中此字段也没有设置默认值。这是MySQL5出来后搞出来的东东,认真看一下my.ini文件。我用的宝塔查看了下mysql配置:#..._general error: 1364 field 'client_id' doesn't have a default value