In a stored procedure, is it possible to get the total number or rows updated by different statements?
I have a bunch of stored procedures that look like something this
CREATE PROCEDURE example() BEGIN UPDATE STATEMENT A; UPDATE STATEMENT B; UPDATE STATEMENT C; END//
When I run them through MySQLWorkbench after it completes they will return a response of,
5 row(s) affected
However that is only the count for the rows updated by the last statement, not all of the rows effected by the stored procedure.
Is there a way to write the stored procedure so that the number of rows effected will be the total number of rows instead of just the last update?