I am converting from Access 2.0 to MySQL and I am going through all of
my code to make it compatible with MySQL. I was testing my Update for
one of my queries and I don't know if I found a bug or if MySQL was
designed to do this.
In my program I pass an UPDATE string to MySQL. There can be times
when there really isn't anything to UPDATE but the string is passed
anyway. In Access it would run the query and just overwrite everything.
In MySQL it does nothing if there are no changes.
Here is a sample UPDATE:
UPDATE tblQuotes SET CompanyContact= "George Bush", CompanyName= "Hello
There"
WHERE (QuoteNumber= 55 AND Revision= "Initial"
If the data in the DB is the same then nothing happens. If I make a
change to either of the fields then it updates. Was MySQL designed this
way?
