title: SELECT INTO local variable undeclared?
body: <p>I have the following in an sql file I am executing...</p>
  
  <pre><code>DECLARE rowcount INT;
  
  SELECT COUNT(*) INTO rowcount
  FROM VRG_PROBLEM_ACCOUNT PA 
  WHERE NEW.CustName = PA.CustNAME 
  AND NEW.AreaCode = PA.AreaCode 
  AND NEW.PhoneNumber = PA.PhoneNumber;
  </code></pre>
  
  <p>And yet I'm getting</p>
  
  <pre><code>ERROR 1327 (42000): Undeclared variable: rowcount
  </code></pre>
  
  <p>In another file I am doing the same type of SELECT...INTO localvariable and it works.</p>