I have a MySQL table where I need to store the TIMESTAMP from when the row was created (registration TIMESTAMP). How do I create a field that is only TIMESTAMPed when it is created, and never when the row is updated?
1
-
possible duplicate of mysql timestamp only on createPekka– Pekka2011-01-09 17:55:14 +00:00Commented Jan 9, 2011 at 17:55
Add a comment
|
3 Answers
when you create the table you put the default value of the column to be current_timestamp(). Somewhere along these lines.
create table `x` (
id integer auto_increment not null,
timestamp TIMESTAMP default current_timestamp
data CHAR(100)
);
and you don't set the field on insert/updates.
Comments
Whenever you create a new row simply add the TIMESTAMP to it. ALternatively you make it the default
CREATE TABLE your_table(name VARCHAR32, your_time TIMESTAMP DEFAULT CURRENT_TIMESTAMP);
Comments
On the MySQL INSERT statement, I passed a value of NOW() which records the current time.