Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

创建success_killed表没有设置create_time自动更新 #39

Open
LinG955 opened this issue May 18, 2020 · 2 comments
Open

创建success_killed表没有设置create_time自动更新 #39

LinG955 opened this issue May 18, 2020 · 2 comments

Comments

@LinG955
Copy link
Contributor

LinG955 commented May 18, 2020

``create_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间'
要设置create_time自动更新，因为insertSuccessKilled()没有插入create_time，create_time为默认值00-00-00 00:00:00。不然在测试queryByIdWithSeckill()时程序会报错：Caused by: com.mysql.cj.exceptions.DataReadException: Zero date value prohibited。

TIM截图20200518200101
@LinG955
Copy link
Contributor Author

LinG955 commented May 18, 2020

version:8.0.19

@codingXiaxw
Copy link
Owner

可以提个pr 我给你合进去

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
2 participants
@codingXiaxw @LinG955