What happens if you put third TIMESTAMP column.?. Will that be
updated?. Just curios.
Nilesh
-Original Message-
From: Paul DuBois [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 03, 2002 12:42 PM
To: Paul Tomsic; [EMAIL PROTECTED]
Subject: Re: verification upon update, help, please
At 12:07 -0400 7/3/02, Paul Tomsic wrote:
>Does MySQL prevent updates from occurring when the values involved
>are the same as the database's current state.
I don't know if "prevent" is the word exactly. It doesn't bother to update
the row unless you actually change a value. The phenonenon you
Does MySQL prevent updates from occurring when the values involved are the
same as the database's current state.
For instance, if I've got a table
create table updater(
id int not null primary key auto_increment,
is_active int not null default 1
};
insert into updater(is_active) values (1);
in
