報(bào)這個(gè)錯(cuò)誤,哪里錯(cuò)了啊
這是源碼
CREATE TABLE seckill (
?`seckill_id` BIGINT NOT NULL AUTO_INCREMENT COMMENT '商品庫存ID',
?`name` VARCHAR (120) NOT NULL COMMENT '商品名稱',
?`number` INT NOT NULL COMMENT '庫存數(shù)量',
?`create_time` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '創(chuàng)建時(shí)間',
?`start_time` TIMESTAMP NOT NULL COMMENT '秒殺開啟時(shí)間',
?`end_time` TIMESTAMP NOT NULL COMMENT '秒殺結(jié)束時(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 = '秒殺庫存表' ;
--初始化數(shù)據(jù)
insert into
? ?seckill (name , number , start_time , end_time)
VALUES
? ?('100元秒殺ipad' , 100 , '2017-04-19 00:00:00' , '2017-04-20 00:00:00'),
? ?('200元秒殺小米5' , 100 , '2017-04-19 00:00:00' , '2017-04-20 00:00:00'),
? ?('300元秒殺iphone6s' , 100 , '2017-04-19 00:00:00' , '2017-04-20 00:00:00');
求大神
2017-04-18
數(shù)據(jù)庫url有沒有characterEncoding。。。等參數(shù)