A simple way to deal with 1264 Out of range value for column errors reported by mysql
The following article is about a simple way to deal with mysql 1264 Out of range value for column errors. The secret of the text is to be close to the topic. So, no gossip, let's go straight to the following, I believe you will benefit from the simple way to deal with the 1264 Out of range value for column error in mysql report.
Solution method
Modify my.cnf
Sql_mode = ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
It is mainly to get rid of:
STRICT_TRANS_TABLES
Is there anything you don't understand about the above simple method of dealing with mysql 1264 Out of range value for column error? Or if you want to know more about it, you can continue to follow our industry information section.
