Fetch rows_affected after each INSERT/UPDATE. Tally them in @variables, if you
like. The information is not (I think) available after COMMIT.
> -Original Message-
> From: Neil Tompkins [mailto:neil.tompk...@googlemail.com]
> Sent: Tuesday, July 02, 2013 4:30 AM
> To: [MySQL]
> Subject:
2013/07/02 12:29 +0100, Neil Tompkins
I have a number of INSERT and UPDATE statements in a MySQL Stored
Procedure, that works in the form of START TRANSACTION followed by COMMIT.
Also I am handling any EXCEPTION.
However, after calling COMMIT, how can I get the number of Rows that were
