8 messages in com.mysql.lists.perlRe: mysql timestamp question
FromSent OnAttachments
Todd Finney09 Dec 1999 07:10 
Autarch09 Dec 1999 08:34 
Autarch09 Dec 1999 08:36 
Jochen Wiedmann09 Dec 1999 12:00 
Jochen Wiedmann09 Dec 1999 12:05 
Jochen Wiedmann09 Dec 1999 12:29 
Jochen Wiedmann09 Dec 1999 12:29 
Michael Widenius14 Jan 2000 07:23 
Subject:Re: mysql timestamp question
From:Michael Widenius (mon@monty.pp.sci.fi)
Date:01/14/2000 07:23:18 AM
List:com.mysql.lists.perl

Hi again!

I was scanning through some old mails to check if we had some unsolved things before doing a new relase and stumbled across the following mail:

"Jochen" == Jochen Wiedmann <jo@ispsoft.de> writes:

Jochen> Todd Finney wrote:

My question is, how do you specify explicitly the timestamp column in an update statement without actually changing the value? Am I reading this wrong?

Jochen> The trick is reading the old value before doing the update and then Jochen> using the old value explicitly.

For example

UPDATE table SET A=A+1, timestamp_column=timestamp_column;

Will keep the old timestamp value

Regards, Monty

PS: Sorry for the delay, hope late was better than never.