title: PHPmyadmin MYSQL: Viewing rows affected by a transaction
body: <p>I've started using </p>
  
  <pre><code>BEGIN;
  &lt;SQL CODE HERE&gt;;
  ROLLBACK;
  </code></pre>
  
  <p>To test queries out before commiting the results. It's a very useful to avoid screwing up data, even on local and test databases.</p>
  
  <p>One thing I dislike, however, is that all I get returned is the number of rows affected Like so:</p>
  
  <pre><code>BEGIN;# MySQL returned an empty result set (i.e. zero rows).
  
  
  UPDATE agenda SET is_ars = 0, question_bank_id = null WHERE session_name LIKE '%closing%';# 1 row affected.
  
  
  ROLLBACK;# MySQL returned an empty result set (i.e. zero rows).
  </code></pre>
  
  <p>Is there any way to actually SELECT the row that was affected or see it, so that I can ensure my query hit my target, and not something else?</p>
  
  <p>Thanks</p>