Hello.
>But I don't want the value to be updated automatically after an update.
Use DEFAULT CURRENT_TIMESTAMP. You can see that after an update, the
value of the timestamp column didn't changed:
mysql> create table timeup(a int,b timestamp default current_timestamp);
Query OK, 0 rows aff
Hi,
I want to save date and time of the creation of a row in a field.
That could be handled by a timestamp, I know that.
But I don't want the value to be updated automatically after an update.
I tried
.
creation datetime not null default now()
.
in the create table statement, but got an er