2 messages in com.mysql.lists.javaAffected rows and getUpdateCount
FromSent OnAttachments
André Næss14 Oct 2005 01:08 
Mark Matthews14 Oct 2005 06:39 
Subject:Affected rows and getUpdateCount
From:André Næss (andr@gmail.com)
Date:10/14/2005 01:08:30 AM
List:com.mysql.lists.java

Looking at the changelog for the MySQL Connector/J I find an entry from 2003 saying that getUpdateCount now returns the number of matched rows rather than the number of affected rows. Unfortunately, I need the latter.

In the bugs database I found that a function has been added to MySQL 5.0 which allows you to extract the number of affected rows from the previous query, but as I run 4.1 that is not an option.

After some searching I found this post: http://lists.mysql.com/java/6027 which initially gave me some hope, because I run Connector/J 3.1. But alas, I have not been able to locate any such parameter. Am I overlooking something, or has this parameter not been added? Or is there some other way of extracting the number of affected rows after executing an update?

And just to make sure there's no misunderstandings: by affected rows I mean the value that you get in the "Changed" field when you execute an update in the client.