MySQL实现
TIMESTAMP数据类型的方式，实际上是将纪元时间存储在数据库中。因此，如果您想将其显示为int，则可以使用
TIMESTAMP默认值为的列
CURRENT_TIMESTAMP并将其应用于该列
UNIX_TIMESTAMP()：
CREATE TABLE foo( created TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP);insert into foo values (current_Date()),(now());select unix_timestamp(created) from foo;+-------------------------+| unix_timestamp(created) |+-------------------------+| 1300248000 || 1300306959 |+-------------------------+2 rows in set (0.00 sec)
但是，如果您确实希望该列的数据类型为
INT，则可以使用R. Bemrose的建议并通过触发器设置它：
CREATE TABLE foo( created INT NULL);delimiter $$create trigger tr_b_ins_foo before insert on foo for each rowbegin if (new.created is null) then set new.created = unix_timestamp(); end if;end $$delimiter ;insert into foo values (unix_timestamp(current_Date())), (null);select created from foo;+------------+| created |+------------+| 1300248000 || 1300306995 |+------------+2 rows in set (0.00 sec)
