Uncategorized

mysql how to ignore error doesn’t have a default value

This is caused by the STRICT_TRANS_TABLES SQL mode defined in the MySQL my.ini file. Removing that setting and restarting MySQL should fix the problem, or, get into the mysql command and: select @@GLOBAL.sql_mode +——————————————–+ | @@GLOBAL.sql_mode | +——————————————–+ | STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION | +——————————————–+ 1 row in set (0.00 sec) Then do: mysql> set GLOBAL sql_mode=’NO_ENGINE_SUBSTITUTION’;