语句出现了错误,希望大佬们帮忙,sql语句和错误都贴在下面了
mysql> 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` timetamp 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=utf-8 comment='秒杀库存表';
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'timetamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
PRIMARY KEY(' at line 7