this error can be fixed by running?

SET?SQL_MODE='ALLOW_INVALID_DATES';

https://www.cnblogs.com/jinjiyese153/p/7300510.html

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

mysql> set names 'gbk';

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>

end_time 默認的日期 不再timestamp范圍之內,默認范圍是'1970-01-01 00:00:00'到2037年。