如何解决此错误，字段"STATE_REGION"在MySQl 5.6中没有默认值 [英] How to resolve this error Field 'STATE_REGION' doesn't have a default value in MySQl 5.6

问题描述

我遇到了类似以下的错误

I had an error like the following

字段"STATE_REGION"-字段名称在以下位置没有默认值 MySQL 5.6.

Field 'STATE_REGION' - Field Name doesn't have a default value in MySQL 5.6.

我通过在早期版本的MySQL中更改sql_mode = '';来解决了该问题

I fixed the issue by changing sql_mode = ''; in previous version of MySQL

但是在MySQL 5.6中失败

But failed in MySQL 5.6

如何在MySQL 5.6中解决此问题.请帮助，非常感谢.

How to fix this issue in MySQL 5.6. Please help any help is much appreciated.

推荐答案

为我的问题提供解决方案
只需在INSERT

Got Solution To my Problem
Just add IGNORE after INSERT

将IGNORE插入tblname(....

INSERT IGNORE INTO tblname(....

"INSERT IGNORE"；与"INSERT ... ON DUPLICATE KEY UPDATE"相对应；

谢谢:)

这篇关于如何解决此错误，字段"STATE_REGION"在MySQl 5.6中没有默认值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！