问题描述
我正在尝试这样做,但 MySQL 似乎不允许我这样做.是否有解决此问题的方法,还是希望我始终在 INSERT 查询中包含该函数?
I'm trying to do this, but it seems like MySQL isn't allowing me. Is there a solution to this issue or am I expected to always include the function in my INSERT queries?
我知道接受 CURRENT_TIMESTAMP 默认值的 TIMESTAMP 类型,但我的客户坚持在数据库中使用纪元时间.
I'm aware of the TIMESTAMP type that accepts a CURRENT_TIMESTAMP default, but my client insisted on using epoch time in the database.
推荐答案
MySQL 实现TIMESTAMP
数据类型的方式,实际上是在数据库中存储纪元时间.所以你可以只使用 TIMESTAMP
列的默认值 CURRENT_TIMESTAMP
并应用 UNIX_TIMESTAMP()
如果你想将它显示为内部:
The way MySQL implements the TIMESTAMP
data type, it is actually storing the epoch time in the database. So you could just use a TIMESTAMP
column with a default of CURRENT_TIMESTAMP
and apply the UNIX_TIMESTAMP()
to it if you want to display it as an int:
但是,如果您确实希望列的数据类型为 INT
,则可以使用 R. Bemrose 的建议并通过触发器进行设置:
However, if you really want the datatype of the column to be INT
, you can use R. Bemrose's suggestion and set it via trigger:
这篇关于是否可以在 MySQL 中创建一个具有 UNIX_TIMESTAMP 默认值的列?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持跟版网!