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?
Thank you for visiting the Q&A section on Magenaut. Please note that all the answers may not help you solve the issue immediately. So please treat them as advisements. If you found the post helpful (or not), leave a comment & I’ll get back to you as soon as possible.
That is correct. In SQL code that would be:
CREATE TABLE `table` ( ... `date` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, ... )
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