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 = '秒殺數據庫';

報錯為:

[2017-04-21 09:25:39] [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

[2017-04-21 09:25:39] COMMENT '商品庫存id',

[2017-04-21 09:25:39] ' at line 2