mysql - 如何在数据库中存储当前时间

Question

我想在 mysql 中有一个必须自动生成当前时间的字段，比如记录插入到其中的时间。

请帮帮我..........

Answer 1

来自 MySQL :

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.