MYSQL 语句 DEFAULT CURRENT_TIMESTAMP这句话出错怎么回事？
MYSQL 语句 DEFAULT CURRENT_TIMESTAMP这句话出错怎么回事？
create table seckill(
`seckill_id` bigint not null AUTO_INCREMENT COMMENT '商品库存id',
`name` varchar(120) not null COMMENT '商品名称',
`number` int not null COMMENT '库存数量',
`start_time` timestamp not null COMMENT '秒杀开启时间',
`end_time` timestamp not null COMMENT '秒杀结束时间',
`create_time` timestamp not null DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
PRIMARY KEY (seckill_id),
key idx_start_time(start_time),
key idx_end_time(end_time),
key idx_create_time(create_time)
)ENGINE=InnoDB AUTO_INCREMENT=1000 DEFAULT CHARSET=utf8 COMMENT='秒杀库存表'
