MySQL时间戳默认值无效

Question

我正在尝试在 MYSQL 5.7.23 (phpmyadmin) 上创建一个具有默认时间戳的表

CREATE TABLE mytable(
    id MEDIUMINT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
    created_at TIMESTAMP DEFAULT '1970-01-01 00:00:01',
    updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    PRIMARY KEY(id)
);

Answer 1

TIMESTAMP 值的范围是从 '1970-01-01 00:00:01' UTC 到 '2038-01-19 03:14:07' UTC

所以你应该使用

 created_at TIMESTAMP DEFAULT '1970-01-01 00:00:01',

或按照 RaymondNijland 的建议

created_at TIMESTAMP DEFAULT 0

或更改为

created_at datetime DEFAULT '1900-01-01 00:00:01',

https://dev.mysql.com/doc/refman/8.0/en/datetime.html