MySQL 1366 error solution!
Prompt mysql 1366 error general error: 1366 incorrect Integer value:
Cancel the settings of the mysql field unsigned to insert 0!
cdbcommand cannot execute sql statement: sqlstate[HY000]: General Error: 1366 Incorrect Integer Value:Classificationfor columnBUY_CAT_IDat row 1. The SQL statement execute was: insert into `ERP_customer` (`realname`, `tel`, `address`, `spec_con`, `join_time`, `buy_cat_id`) values (:yp0, :yp1, :yp2, :yp3, :yp4, :yp5).
When importing EXCEL, if it is a null value in EXCEL, I set it to “”, it will still be converted to 0 value, and the insertion fails. It is possible to cancel the setting of the field!
![添加外键约束时报错： SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails 。](https://www.shuijingwanwq.com/wp-content/uploads/2022/01/1-11-520x245.png)