Auto TimeStamp new entry to DB (phpMyAdmin)

问题:

If I want each new entry into my db to be automatically timestamped, would I set the Field Type to "timestamp" and have the Default value set to "CURRENT_TIMESTAMP"?

Is this the correct method?

回答1:

That is correct. In SQL code that would be:

CREATE TABLE `table` (
    ...
    `date` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, 
    ...
)

回答2:

Yes, this method is correct:

 create table t(Id int, ts timestamp default current_timestamp)

 insert into t(Id) values (1)

 select * from t

 1;2010-09-01 09:20:09:000