MySQL Forums
Forum List  »  Perl

When UPDATE doesn't work..
Posted by: rowew
Date: September 15, 2006 03:46PM

eg

UPDATE MyTable SET SomeField = 20 WHERE AnotherField = -1

If the table MyTable has no row with AnotherField = -1, obviously no update will take place, and the query will end normally. Is there any way to capture the fact that no update has taken place (other than the obvious trick of determining prior to the update whether AnotherField = -1 exists)? Is the number of changed rows stored anywhere? It is displayed when the update is performed in the MySQL command line interface.

Options: ReplyQuote


Subject
Written By
Posted
When UPDATE doesn't work..
September 15, 2006 03:46PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.