MySQL timestamp的默认值怎么设置？

Answer 1

2038 is still far away. . .

The current solution is to use CURRENT_TIMESTAMP for insert columns

Answer 2

Reference

Answer 3

If the time is short, use datetime. Our company currently uses the default null

Answer 4

receive_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, this is what I always use