CREATE TABLE seckill ( `seckill_id` BIGINT NOT NULL AUTO_INCREMENT COMMENT '商品库存ID', `name` VARCHAR (120) NOT NULL COMMENT '商品名称', `number` INT NOT NULL COMMENT '库存数量', `create_time` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `start_time` TIMESTAMP NOT NULL COMMENT '秒杀开启时间', `end_time` TIMESTAMP NOT NULL COMMENT '秒杀结束时间', PRIMARY KEY (seckill_id), KEY idx_create_time (create_time), KEY idx_start_time (start_time), KEY idx_end_time (end_time) ) ENGINE = INNODB AUTO_INCREMENT = 1000 DEFAULT CHARSET = utf8 COMMENT = '秒杀库存表' ; ERROR 1067 (42000): Invalid default value for 'start_time'
我执行的你的SQL语句没有出现问题。我的MYSQL的版本:5.7.32-log