Get the number of affected rows in a MySQL update statement?

Question

I have stored procedure in MySQL, something like the below:

create procedure SP_Test (input1 varchar(20))
begin
update Table1 set Val1='Val' where country=input1;
//I want to see if this update changed how many rows and 
//do some specific action based on this number
....
end

How can I determine how many rows were changed by this update?

Answer 1

Use ROW_COUNT():

SELECT ROW_COUNT();