There are 2 solutions mentioned below:
Solution 1
MySQL is most likely in STRICT SQL mode. Try to execute SQL query SET GLOBAL sql_mode=''
or edit your my.cnf / my.ini to make sure you aren’t setting STRICT_ALL_TABLES
and/or STRICT_TRANS_TABLES
.
Solution 2
If Solution-1 is not working then try Solution-2 as given in below steps:
- Run MySQL Administrator tool as Administrator.
- Then go to Startup Variable.
- Then go to the Advance tab.
- find SQL Mode and remove the
STRICT_ALL_TABLES
and/orSTRICT_TRANS_TABLES
and then Click on Apply Changes. - Restart MySQL Server.
- Done.
Note: I have tested these solutions in MySQL Server 5.7
If editing that file doesn’t fix the issue, see http://dev.mysql.com/doc/refman/5.6/en/option-files.html for other possible locations of config files