[MySQL] 自动当前时间戳

This topic created in 4642 days ago, the information mentioned may be changed or developed.

知道这样的
created timestamp not null default current_timestamp;

获取时间戳的函数:
select unix_timestamp();

有没有字段为int型自动插入时间戳的呢?
-- created int(11) not null default (当前时间戳) ???

TIMESTAMP

null

int

2 replies • 1970-01-01 08:00:00 +08:00

1

zzNucker

Sep 5, 2013

应该没的吧自动时间戳只能是timestamp类型

2

qsun

Sep 5, 2013

可以做个trigger, on update/insert