插入數(shù)據(jù)報(bào)錯(cuò)
cha插入數(shù)據(jù)報(bào)錯(cuò)： Incorrect string value: '\xF0\x9F...' for column 'XXX' at row 1 有沒(méi)有和我一樣的呢？
3 回答
舉報(bào)
0/150
提交
取消
cha插入數(shù)據(jù)報(bào)錯(cuò)： Incorrect string value: '\xF0\x9F...' for column 'XXX' at row 1 有沒(méi)有和我一樣的呢？
舉報(bào)
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也加上去了，導(dǎo)致前后列數(shù)不一樣，比如insert into 表名 (field1,field2,field3) values('a','b')這樣前面的是三列，后面卻只有二個(gè)值，這就會(huì)出現(xiàn)這個(gè)錯(cuò)誤的。
2018-01-27
表 列名不對(duì)應(yīng)吧