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.tompkins@stripped]
> Sent: Tuesday, July 02, 2013 4:30 AM
> To: [MySQL]
> Subject: Get Affected Rows after Stored Procedure COMMIT
> 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
> affected either INSERTED or UPDATTED ?