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?'秒殺結(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)
)ENGING=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?MySQL?server?version?
?for?the?right?syntax?to?use?near
??''seckill_id'?bigint?NOT?NULL?AUTO_INCREMENT?COMMENT?'商品庫(kù)存id','name'?var'?at?line?2
??說明?的本地?cái)?shù)據(jù)庫(kù)的版本是5.6.26-log
??謝謝~
2019-05-17
字段名稱，不是單引號(hào)，是`，“TAB”鍵上方的那個(gè)鍵。
2019-05-20
謝謝 我當(dāng)時(shí)提完問題，第二天才發(fā)現(xiàn)原因所在，忘了關(guān)閉問題了；收到回復(fù)時(shí)正上著班 想著下班回復(fù)，后來一研究別的給忘了回復(fù)了?
總之，謝謝了
2019-05-17