Shulou(Shulou.com)06/01 Report--

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.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.