Resolve : MYSQL #1366 – Incorrect integer value: ” for column ‘id’ at row 1

Today when import SQL into sheet , an error happen :

#1366 – Incorrect integer value: ” for column ‘id’ at row 1,after searching info , i notice it is because of mysql 5.x ,  if the value is null , before can be ” , today has to write NULL。

Official news also says , for solve this  “bug”, can remove default value during install MYSQL :  enable strict SQL mode

But I have installed !!!  If by this way , I have to revised code to insert NULL in the future , but the code is not my works too !

So if try to solve , we can do it in server “my.ini” . Here is the method :

In my.ini search sql-mode,default sql-mode=”STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION”

change it to sql-mode=”NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION”,then reboo MYSQL , trouble resolved .

Another thing is  : I am using BT panel to control , so my.ini locate in “/etc/my.cnf ” ..

——- write here hope to help others , good luck guys !