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 !