Home  >  Article  >  Database  >  What should I do if navicat reports error 1265 when importing sql?

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

爱喝马黛茶的安东尼
爱喝马黛茶的安东尼Original
2019-08-15 13:03:055646browse

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!

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn