CREATE TABLE seckill (
?'seckill_id' ?BIGINT ? ? ? NOT NULL AUTO_INCREMENT
?COMMENT '商品庫(kù)存id',
?'name' ? ? ? ?VARCHAR(120) NOT NULL
?COMMENT '商品名稱',
?'number' ? ? ?INT ? ? ? ? ?NOT NULL
?COMMENT '庫(kù)存數(shù)量',
?'start_time' ?TIMESTAMP ? ?NOT NULL
?COMMENT '秒殺開始時(shí)間',
?'end_time' ? ?TIMESTAMP ? ?NOT NULL
?COMMENT '秒殺開始時(shí)間',
?'create_time' TIMESTAMP ? ?NOT NULL DEFAULT current_timestamp
?COMMENT '創(chuàng)建時(shí)間',
?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 = '秒殺數(shù)據(jù)庫(kù)';

報(bào)錯(cuò)為:

[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 '商品庫(kù)存id',

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