RE: Get Affected Rows after Stored Procedure COMMIT

2013-07-02 Thread Rick James
L] > 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,

Re: Get Affected Rows after Stored Procedure COMMIT

2013-07-02 Thread hsv
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

Get Affected Rows after Stored Procedure COMMIT

2013-07-02 Thread Neil Tompkins
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 ? Tha