怀疑你用的不是 datetime,而是 timestamp. 贴出你的 show create table 和你的 insert语句 以供分析TIMESTAMP A timestamp. The range is '1970-01-01 00:00:01' UTC to '2038-01-19 03:14:07' UTC. TIMESTAMP values are stored as the number of seconds since the epoch ('1970-01-01 00:00:00' UTC). A TIMESTAMP cannot represent the value '1970-01-01 00:00:00' because that is equivalent to 0 seconds from the epoch and the value 0 is reserved for representing '0000-00-00 00:00:00', the “zero” TIMESTAMP value.
你说对了,是timestamp类型,我写错了。非常感谢你和其它人的帮助!