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?'秒殺開(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ù)存表';
2016-11-21
我今天也遇到這個(gè)問(wèn)題了，不是英文狀態(tài)下的'而是`，英文狀態(tài)下打鍵盤(pán)上1前面的那個(gè)鍵，就是按下shift顯示~的鍵，字段名上要用這個(gè)，不然報(bào)錯(cuò)。
2016-11-11
或者直接去掉字段的引號(hào) ' '?
2016-11-11
' ' -> ` ` ?這就是變化
2016-10-11
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 '秒殺開(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ù)存表';