MySQL自动存储每一行​​的日期时间

2021-11-30 00:00:00 datetime sql mysql audit

在 MySQL 中，我厌倦了将列 dt_created 和 dt_modified(分别是创建和上次修改的日期时间戳)添加到我拥有的所有表中在我的数据库中.

In MySQL, I'm sick of adding the columns dt_created and dt_modified (which are date time stamps for creation and last modified respectively) to all the tables I have in my database.

每次我INSERT 或UPDATE 数据库时，我都必须使用NOW() 关键字.这贯穿了我的坚持.

Every time I INSERT or UPDATE the database, I will have to use the NOW() keyword. This is going all over my persistence.

是否有任何有效的替代方法可以让 MySQL 至少自动存储插入行的数据时间并让我检索它?

Is there any efficient alternative where MySQL can automatically store at least the datatime of the row that is inserted and let me retrieve it?

推荐答案

可以使用DEFAULT约束来设置时间戳:

You can use DEFAULT constraints to set the timestamp:

ALTER TABLE
 MODIFY dt_created datetime DEFAULT CURRENT_TIMESTAMP

ALTER TABLE
 MODIFY dt_modified datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP

那么您就不必在 INSERT/UPDATE 语句中指定 NOW().

Then you wouldn't have to specify NOW() in your INSERT/UPDATE statements.

参考:TIMESTAMP 属性

相关文章