mysql自动存储记录创建时间戳 [英] mysql automatically store record creation timestamp

问题描述

MySQL是否有某种方法可以在创建时自动将时间戳存储在记录行中.我试图使用带有current_timestamp作为默认值的timestamp(数据类型)，但是后来意识到每次记录更新时，它都会被更新.我只需要一些可以存储创建时间戳记的东西.

Is there some way mysql can store timestamp automatically in a record row whenever that it is created. I was trying to use timestamp(data type) with current_timestamp as default value but then realised this will get updated everytime the record is updated. I just need something that will store create timestamp.

谢谢

推荐答案

设置对于现有表，请使用 ALTER TABLE语句:

ALTER TABLE your_table
ALTER COLUMN date_column SET DEFAULT CURRENT_TIMESTAMP

除非您为date_column指定一个值，否则默认值为date&. INSERT语句运行的时间. NULL和DEFAULT或有效值，否则将使用默认约束，假设该列为可空.

Unless you specify a value to for the date_column, the default will be the date & time the INSERT statement was run. NULL and DEFAULT or valid values to use the default constraint otherwise, assuming the column is nullable.

这篇关于mysql自动存储记录创建时间戳的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！