MySQL时间类型配置

MySQL时间类型配置

时间类型设置不为空的默认值

时间类型

类型范围DATE‘1000-01-01’ to ‘9999-12-31’DATETIME‘1000-01-01 00:00:00’ to ‘9999-12-31 23:59:59’TIMESTAMP‘1970-01-01 00:00:01’ UTC to '2038-01-19 03:14:07’UTC

设置不为空的默认值

//去除空值 UPDATE `pre_tabel` SET `time`='1970-01-02 00:00:00' WHERE `time`<'1970-01-02 00:00:00'; UPDATE `pre_tabel` SET `time`='1970-01-02 00:00:00' WHERE ISNULL(time); //设置默认值 ALTER TABLE `pre_tabel` MODIFY COLUMN `time` timestamp(0) NOT NULL DEFAULT '1970-01-02 00:00:00' COMMENT '时间';