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>

你是不是把create_time也加上去了，导致前后列数不一样，比如insert into 表名 (field1,field2,field3) values('a','b')这样前面的是三列，后面却只有二个值，这就会出现这个错误的。

表 列名不对应吧