mysql建表時(shí)出現(xiàn)錯(cuò)誤（ERROR 1067 (42000): Invalid default value for 'end_time'）
ERROR 1067 (42000): Invalid default value for 'end_time'
涼橙2
2019-04-28
4 回答
舉報(bào)
0/150
提交
取消
2020-08-10
this error can be fixed by running?
2019-06-12
https://www.cnblogs.com/jinjiyese153/p/7300510.html
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
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>
2019-04-29
end_time 默認(rèn)的日期 不再timestamp范圍之內(nèi),默認(rèn)范圍是'1970-01-01 00:00:00'到2037年。