Datatruncatedforcolumn in mysql

Datatruncatedforcolumn in mysql

1. Describe your problems first.

The data processed_f in the database is empty and has no value .... When you change the structure of a Data table, the message "Data truncated for column processed_f" appears .. The solution is to assign a value to the processed_f field in the database. At this time, you are saving. This error will not occur.

2. What happened to others on the Internet .. When you want to insert a record in a database in mysql, the Data truncated for column XXXXX error may occur for many reasons, which is caused by inconsistent Data types, check the length of the Data Type to solve this problem.