What should I do if navicat reports error 1265 when importing sql?

When using MySQL to write a database table, a crash occurs. Tracking and debugging found that the write failed and the return value was 1265;

Then open the database separately. Directly writing to the database through SQL statements returns the same error.

Related recommendations: "Navicat for mysql graphic tutorial"

#define WARN_DATA_TRUNCATED 1265

Passing literally means inserting wrong data. Then through the search, we found that one of the fields is of type char, but the inserted data is of type float. Just change the inserted data type to char and the problem will be solved!

The above is the detailed content of What should I do if navicat reports error 1265 when importing sql?. For more information, please follow other related articles on the PHP Chinese website!