List:General Discussion« Previous MessageNext Message »
From:Rick James Date:July 2 2013 7:39pm
Subject:RE: Get Affected Rows after Stored Procedure COMMIT
View as plain text  
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
> 
> Hi,
> 
> 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 ?
> 
> Thanks,
> Neil
Thread
Get Affected Rows after Stored Procedure COMMITNeil Tompkins2 Jul
  • RE: Get Affected Rows after Stored Procedure COMMITRick James2 Jul
  • Re: Get Affected Rows after Stored Procedure COMMIThsv2 Jul