插入數據報錯
cha插入數據報錯： Incorrect string value: '\xF0\x9F...' for column 'XXX' at row 1 有沒有和我一樣的呢？
慕函數1123206
2018-01-25
3 回答
舉報
0/150
提交
取消
2019-05-17
mysql> insert into seckill(name,number,start_time,end_time)
? ? -> values
? ? -> ('1000元秒殺iphone6',100,'2015-11-01 00:00:00','2015-11-02 00:00:00'),
? ? -> ('500元秒殺ipad2',200,'2015-11-01 00:00:00','2015-11-02 00:00:00'),
? ? -> ('300元秒殺小米4',300,'2015-11-01 00:00:00','2015-11-02 00:00:00'),
? ? -> ('200元秒殺紅米note',400,'2015-11-01 00:00:00','2015-11-02 00:00:00');
ERROR 1366 (HY000): Incorrect string value: '\xC3\xEB\xC9\xB1ip...' for column 'name' at row 1
Query OK, 0 rows affected (0.00 sec)
mysql> insert into seckill(name,number,start_time,end_time)
? ? -> values
? ? -> ('1000元秒殺iphone6',100,'2015-11-01 00:00:00','2015-11-02 00:00:00'),
? ? -> ('500元秒殺ipad2',200,'2015-11-01 00:00:00','2015-11-02 00:00:00'),
? ? -> ('300元秒殺小米4',300,'2015-11-01 00:00:00','2015-11-02 00:00:00'),
? ? -> ('200元秒殺紅米note',400,'2015-11-01 00:00:00','2015-11-02 00:00:00');
Query OK, 4 rows affected (0.00 sec)
Records: 4? Duplicates: 0? Warnings: 0
mysql>
2018-06-20
你是不是把create_time也加上去了，導致前后列數不一樣，比如insert into 表名 (field1,field2,field3) values('a','b')這樣前面的是三列，后面卻只有二個值，這就會出現這個錯誤的。
2018-01-27
表 列名不對應吧