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