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: 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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql
