CREATE?TABLE?seckill?(
?`seckill_id`?BIGINT?NOT?NULL?AUTO_INCREMENT?COMMENT?'商品庫存ID',
?`name`?VARCHAR?(120)?NOT?NULL?COMMENT?'商品名稱',
?`number`?INT?NOT?NULL?COMMENT?'庫存數量',
?`create_time`?TIMESTAMP?NOT?NULL?DEFAULT?CURRENT_TIMESTAMP?COMMENT?'創(chuàng)建時間',
?`start_time`?TIMESTAMP?NOT?NULL?COMMENT?'秒殺開啟時間',
?`end_time`?TIMESTAMP?NOT?NULL?COMMENT?'秒殺結束時間',
?PRIMARY?KEY?(seckill_id),
?KEY?idx_create_time?(create_time),
?KEY?idx_start_time?(start_time),
?KEY?idx_end_time?(end_time)
)?ENGINE?=?INNODB?AUTO_INCREMENT?=?1000?DEFAULT?CHARSET?=?utf8?COMMENT?=?'秒殺庫存表'?;
ERROR?1067?(42000):?Invalid?default?value?for?'start_time'
2021-04-09
我執(zhí)行的你的SQL語句沒有出現(xiàn)問題。我的MYSQL的版本:5.7.32-log