mysql新建字段时 timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' 报错

Question

这是为什么，网上大家都可以，为什么就我不行。。。我报错是Invalid default value for 'sent_time'

巴扎黑 · Answer

This default value is not allowed by default starting from 5.7. It is recommended to check the official website documentation.

PHP中文网 · Answer

It is recommended to use int to save time

高洛峰 · Answer

What is your timestamp field type?
ps: In addition, it was mentioned above that the int format is not optimal in all scenarios

大家讲道理 · Answer

Timestamp supports a limited year range, but occupies 2 bytes. Datetime can support 0000 to 9999, but occupies 4 bytes