Resolution about MySQL appearing 1264 out of range value for column errors

Reason:
A strict check of the new version of MySQL on the field. after MySQL is usually installed under Linux, the default Sql_mode value is empty, in which case MySQL performs an irregular check, and if the length of the field to be inserted exceeds the length defined by the column, then MySQL does not terminate the operation. Instead, the subsequent characters are automatically truncated to continue with the insert operation! But under Windows it doesn't. It's a direct stop to report the above error!

Workaround

Modify MY.CNF

Sql_mode = Error_for_division_by_zero,no_auto_create_user,no_engine_substitution

The main is removed:

Strict_trans_tables

Reference:

Http://www.fyhqy.com/post-225.html

Resolution about MySQL appearing 1264 out of range value for column errors