MySQL ERROR 1366 (HY000): Incorrect integer value: ” for column ‘id’ at row 1 Problem & Fix

MySQL throw the following error message on insert or update statement executed

ERROR 1366 (HY000): Incorrect integer value: '' for column 'id' at row 1

1	ERROR 1366 (HY000): Incorrect integer value: '' for column 'id' at row 1

Try to update string value into integer column, and strict sql mode is enabled.

Mainly occurred on MySQL 5.x or above.

Update /etc/my.cnf , and remove STRICT_TRANS_TABLES from sql-mode

#sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
to
sql-mode="NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"

#sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"

sql-mode="NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"