CREATE?TABLE?seckill(
'seckill_id'?bigint?NOT?NULL?AUTO_INCREMENT?COMMENT?'商品庫存id',
'name'?varchar(120)?NOT?NULL?COMMENT?'商品名稱',
'number'?int?NOT?NULL?COMMENT?'庫存數(shù)量',
'start_time'?timestamp?NOT?NULL?COMMENT?'秒殺開啟時間',
'end_time'?timestamp?NOT?NULL?COMMENT?'秒殺結(jié)束時間',
'create_time'?timestamp?NOT?NULL?DEFAULT?CURRENT_TIMESTAMP?COMMENT?'創(chuàng)建時間',
PRIMARY?KEY?(seckill_id),
key?idx_start_time(start_time),
key?idx_end_time(end_time),
key?idx_create_time(create_time)
)ENGING=InnoDB?AUTO_INCREMENT=1000?DEFAULT?CHARSET=utf8?COMMENT='秒殺庫存表';
錯誤日志：
ERROR?1064?(42000):?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?COMMENT?'商品庫存id','name'?var'?at?line?2
??說明?的本地數(shù)據(jù)庫的版本是5.6.26-log
??謝謝~