                        課程
                    
                        /后端開發
                        
                            /Java
                        
                        /Java高并發秒殺API之業務分析與DAO層

這樣的報錯內容

?Error attempting to get column 'create_time' from result set.? Cause: java.sql.SQLException: Value '0000-00-00 00:00:00' can not be represented as java.sql.Timestamp

; ]; Value '0000-00-00 00:00:00' can not be represented as java.sql.Timestamp; nested exception is java.sql.SQLException: Value '0000-00-00 00:00:00' can not be represented as java.sql.Timestamp

pert

2020-05-10

源自：Java高并發秒殺API之業務分析與DAO層 4-9

關注問題我要回答

1005

操作

收起

2 回答

JA_JA
2020-05-18

CREATE?TABLE?success_killed(
???`seckill_id`?BIGINT?NOT?NULL?COMMENT?'秒殺商品ID',
???`user_phone`?BIGINT?NOT?NULL?COMMENT?'用戶手機號',
???`state`?TINYINT?NOT?NULL?DEFAULT?-1?COMMENT?'狀態標識:-1:無效?0:成功?1:已付款?2:已發貨',
????`create_time`?TIMESTAMP?NOT?NULL?DEFAULT??CURRENT_TIMESTAMP??COMMENT?'創建時間',
????PRIMARY?KEY?(seckill_id,user_phone),/*聯合主鍵*/
???KEY?idx_create_time(create_time)
)ENGINE=INNODB?DEFAULT?CHARSET=utf8?COMMENT='秒殺成功明細表';