1、错误描述

 

mysql> insert into t_student_info values (2016010101,'张三',23,'男','2323254343','湖北省武汉市洪山区');
ERROR 1366 (HY000): Incorrect string value: '\xE5\xBC\xA0\xE4\xB8\x89' for column 'name' at row 1
mysql> insert into t_student_info values (2016010101,'张三',23,'男','2323254343','湖北省武汉市洪山区');
ERROR 1366 (HY000): Incorrect string value: '\xE5\xBC\xA0\xE4\xB8\x89' for column 'name' at row 1
mysql> insert into t_student_info values('2016010101','zhangsan','man','56323232','湖北省武汉市');
ERROR 1136 (21S01): Column count doesn't match value count at row 1
mysql> insert into t_student_info values('2016010101','zhangsan','man','56323232','湖北省武汉市');
ERROR 1136 (21S01): Column count doesn't match value count at row 1
mysql> insert into t_student_info values('2016010101','zhangsan','23','man','56323232','湖北省武汉市');
ERROR 1366 (HY000): Incorrect string value: '\xE6\xB9\x96\xE5\x8C\x97...' for column 'address' at row 1
mysql> insert into t_student_info values('2016010101','zhangsan','23','man','56323232','hubei');
Query OK, 1 row affected (0.00 sec)

mysql> select * from t_student_info;
+------------+----------+------+------+----------+---------+
| id         | name     | age  | sex  | qq       | address |
+------------+----------+------+------+----------+---------+
| 2016010101 | zhangsan |   23 | man  | 56323232 | hubei   |
+------------+----------+------+------+----------+---------+
1 row in set (0.00 sec)

mysql> insert into t_student_info values('2016010102','zhangnan','21','man','563232312','市');
ERROR 1366 (HY000): Incorrect string value: '\xE5\xB8\x82' for column 'address' at row 1
mysql> 

2、错误原因

 

（1）ERROR 1136 (21S01): Column count doesn't match value count at row 1

     这个错误是由于插入的列与表中的字段不对应，数据类型不匹配

 

（2）ERROR 1366 (HY000): Incorrect string value: '\xE5\xB8\x82' for column 'address' at row 1

     这个错误是由于MySQL不能识别中文，导致报错

 

3、解决办法

（1）对于错误一，比对字段的个数以及数据类型，保证一致

（2）对于错误二，修改MySQL编码格式

再分享一下我老师大神的人工智能教程吧。零基础！通俗易懂！风趣幽默！还带黄段子！希望你也加入到我们人工智能的队伍中来！https://blog.csdn.net/jiangjunshow