php - 如何不更新时间戳字段

Question

项目是用php写的。
mysql 中有时间戳字段，它会自动更新。在一种情况下，我不需要更新此字段。我可以在没有获取时间戳值的情况下给出不更新此查询中的此字段的指令吗？

Answer 1

您应该将其更改为 DEFAULT CURRENT_TIMESTAMP 否则它将自动更新。来自manual :

In a CREATE TABLE statement, the first TIMESTAMP column can be declared in any of the following ways:

With both DEFAULT CURRENT_TIMESTAMP and ON UPDATE CURRENT_TIMESTAMP clauses, the column has the current timestamp for its default value, and is automatically updated.

With neither DEFAULT nor ON UPDATE clauses, it is the same as DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP.

With a DEFAULT CURRENT_TIMESTAMP clause and no ON UPDATE clause, the column has the current timestamp for its default value but is not automatically updated.