改了之后，報(bào)這個(gè)錯(cuò)誤了呢，

ERROR 1293 (HY000): Incorrect table definition;?there can be only one TIMESTAMP column with CURRENT_TIMESTAMP in DEFAULT or ON UPDATE clause

#數(shù)據(jù)庫初始化

#創(chuàng)建數(shù)據(jù)庫

CREATE DataBASE seckill;

#使用數(shù)據(jù)庫

use seckill;

#創(chuàng)建秒殺數(shù)據(jù)庫

CREATE ?TABLE seckill(

seckill_id INT NOT NULL AUTO_INCREMENT COMMENT '商品庫存Id',

name varchar(120) NOT ?NULL ?COMMENT '商品名稱',

number INT ?NOT ?NULL ?COMMENT '庫存量',

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)

)ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='秒殺庫存表';

#初始化數(shù)據(jù)

INSERT ?into

? ? seckill(NAME ,NUMBER ,start_time,end_time)

VALUES

? ? ('1000元秒殺Iphone6', 100,'2015-11-01 00:00:00','2015-11-02 00:00:00'),

? ? ('400元秒殺Ipad2', 200,'2015-11-01 00:00:00','2015-11-02 00:00:00'),

? ? ('3000元秒殺小米', 300,'2015-11-01 00:00:00','2015-11-02 00:00:00'),

? ? ('100元秒殺note', 400,'2015-11-01 00:00:00','2015-11-02 00:00:00');

? ??

#秒殺成功明細(xì)表

#用戶登錄認(rèn)證相關(guān)的信息

CREATE TABLE success_killed(

seckill_id Bigint not NULL ?COMMENT '',

user_phone Bigint NOT NULL ?COMMENT '用戶手機(jī)號(hào)',

state tinyint not NULL ?DEFAULT ?-1 COMMENT '狀態(tài)表示：-1無效 0：成功 1已支付',

create_time TIMESTAMP ?NOT ?NULL ?COMMENT '創(chuàng)建時(shí)間',

PRIMARY KEY (seckill_id,user_phone),#聯(lián)合主鍵

KEY idx_create_time(create_time)

)ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='秒殺成功明細(xì)表';

直接拿去用

哎呀 害死人哈哈?

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 '秒殺開啟時(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='秒殺庫存表';

前面的字段引號(hào)去掉試試？

同錯(cuò)，求助大神

知道原因了，是前面字段名 兩邊不是引號(hào)，是` ,esc下面

同錯(cuò)，我的sql這樣的，總是過不去

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?'秒殺開始時(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='秒殺庫存表';

應(yīng)該是mysql版本的問題，試試去掉引號(hào)。