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.
Subject
Written By
Posted
When UPDATE doesn't work..
September 15, 2006 03:46PM
September 18, 2006 09:41AM
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.