* Henning Heil
> the subject tells almost everything, I try to update records in a table
> and everytime I do this, the timestamp field ist set to now().
>
> how can I keep the previously stored value for this field (there are
> values created before)?
You can assign the current value to it:
UPDATE table1
SET
some_col = 5,
other_col = "test",
timestamp_col = timestamp_col
WHERE
key_col = 123;
--
Roger
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
