                        課程
                    
                        /后端開發(fā)
                        
                            /Java
                        
                        /Java高并發(fā)秒殺API之業(yè)務(wù)分析與DAO層

mysql版本是5.7

mysql> 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)

? ? -> )ENGINE=InnoDB AUTO INCREMENT=1000 DEFAULT CHARACTER SET=utf8 COMMENT='秒殺庫(kù)存表';

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 '，

PRIMARY KEY (seckill_id),

key idx_start_time(start_time),

key idx_end_time(e' at line 7

啊哈呀嘿

2019-03-07

源自：Java高并發(fā)秒殺API之業(yè)務(wù)分析與DAO層 4-1

關(guān)注問題我要回答

2718

操作

收起

1 回答

葉0528
2019-05-17

?-> `create_time`? timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '創(chuàng)建時(shí)間'，
這個(gè)最后的逗號(hào)是中文逗號(hào)。
?)ENGINE=InnoDB AUTO INCREMENT=1000 DEFAULT CHARACTER SET=utf8 COMMENT='秒殺庫(kù)存表';
這個(gè)AUTO_INCREMENT

--?創(chuàng)建秒殺數(shù)據(jù)庫(kù)表
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?DEFAULT?0?COMMENT?'秒殺開啟時(shí)間',
`end_time`?timestamp?not?NULL???DEFAULT?0?COMMENT?'秒殺結(jié)束時(shí)間',
`create_time`?timestamp??NOT?NULL??DEFAULT?CURRENT_TIMESTAMP?COMMENT?'創(chuàng)建時(shí)間',
PRIMARY?KEY?PK_SECKILL_ID(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ù)存表'
;