0

I had an error like the following

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

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

But failed in MySQL 5.6

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

ArunRaj
  • 1,780
  • 2
  • 26
  • 48
Priyanka
  • 1
  • 6

1 Answers1

0

Got Solution To my Problem
Just add IGNORE after INSERT

INSERT IGNORE INTO tblname(....

"INSERT IGNORE" vs "INSERT ... ON DUPLICATE KEY UPDATE"

Thanks:)

Community
  • 1
  • 1
Priyanka
  • 1
  • 6