語句出現了錯誤,希望大佬們幫忙,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
md我知道了,timestamp少了個s