问答详情
源自:4-1 数据库设计与编码

语句出现了错误,希望大佬们帮忙,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

提问者:猜不透的迷 2018-12-04 15:46

个回答

  • 猜不透的迷
    2018-12-04 15:51:04

    md我知道了,timestamp少了个s