                        课程
                    
                        /后端开发
                        
                            /Java
                        
                        /Java高并发秒杀API之业务分析与DAO层

sql报错说实在第二行

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 ='秒杀库存表';

一下是报错信息

[2018-03-05 10:50:28] [42000][1064] 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 ''seckill_id' BIGINT NOT NULL AUTO_INCREMENT

[2018-03-05 10:50:28] COMMENT '商品库存ID',

[2018-03-05 10:50:28] ' at line 2