CREATE?TABLE?seckill(
????'seckill_id'?bigint?NOT?NULL?AUTO_INCREMENT?COMMENT?'商品庫(kù)存id',
????'name'?varchar(120)?NOT?NULL?COMMENT?'商品名稱(chēng)',
????'number'?int?NOT?NULL?COMMENT?'庫(kù)存數(shù)量',
????'start_time'?timestamp?NOT?NULL?COMMENT?'秒殺開(kāi)啟時(shí)間',
????'end_time'?timestamp?NOT?NULL?COMMENT?'秒殺結(jié)束時(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='秒殺庫(kù)存表';

錯(cuò)誤信息是

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ''seckill_id' bigint NOT NULL AUTO_INCREMENT COMMENT '商品庫(kù)存id',

? ? 'name'' at line 2