L PROTECTED]>
> To:
> Sent: November 23, 2005 5:51 AM
> Subject: Re: UPDATE and INDEX updates
>
>
> > Hello.
> >
> > > don't think I will find the answer to this question in the normal
> >manuals
> > > but rather from someone / plac
.
Is it the "row changed" flag or is there a "column changed" flag ??? Mike
- Original Message -
From: "Gleb Paharenko" <[EMAIL PROTECTED]>
To:
Sent: November 23, 2005 5:51 AM
Subject: Re: UPDATE and INDEX updates
> Hello.
>
> > don't
Hello.
> don't think I will find the answer to this question in the normal >manuals
> but rather from someone / place that deals with the internals of the
>system.
> Mike
MySQL internals are available at:
http://dev.mysql.com/doc/internals/en/
Mike OK wrote:
> I did read the man
>
Cc: "MySQL List"
Sent: November 22, 2005 3:05 PM
Subject: Re: UPDATE and INDEX updates
You're going to have to read the manual on the different types of
indexes. Without knowing what kind of index (Hash, B-tree) you're
using and on what kind of table, I cannot help you.
emoved from the index and re-placed?? Does
> MySQL look at each column value first to compare?? Mike
>
> - Original Message -
> From: "sheeri kritzer" <[EMAIL PROTECTED]>
> To: "MySQL List"
> Sent: November 22, 2005 9:31 AM
> Subject:
- Original Message -
From: "sheeri kritzer" <[EMAIL PROTECTED]>
To: "MySQL List"
Sent: November 22, 2005 9:31 AM
Subject: Re: UPDATE and INDEX updates
Mike,
The documentation at
http://dev.mysql.com/doc/refman/5.0/en/update.html explains that MySQL
is aware of the fact th
Mike,
The documentation at
http://dev.mysql.com/doc/refman/5.0/en/update.html explains that MySQL
is aware of the fact that it only needs to update different values --
for instance, it returns only the # of rows changed, not the # of rows
looked at. Given that, I will extrapolate that MySQL is no
Hi
I was wondering how the index process worked internally for UPDATE
statements. If I was to "set" a value for a column with the UPDATE statement
but the value was the same, would MySQL re-work the index?? I can check for
data change for each column inside of my code before UPDATE but wa
