title: Get the number of affected rows in a MySQL update statement?
body: <p>I have stored procedure in MySQL, something like the below:</p>
  
  <pre><code>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
  </code></pre>
  
  <p>How can I determine how many rows were changed by this update?</p>