MySQL is designed to do that. If no data is changed, then MySQL will not perform the update.
>>>>>>>>>>>>>>>>>> Original Message <<<<<<<<<<<<<<<<<< On 2/24/04, 11:36:39 AM, Jacque Scott <[EMAIL PROTECTED]> wrote regarding Updating a Record: > 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? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]