title: how can I know how many rows will update sql affected before I execute it
body: <p>whe can see how many record will be selected in this sql bellow using explain:</p>
  
  <pre><code>explain select * from products 
  </code></pre>
  
  <p><img src="https://i.stack.imgur.com/mWmBW.png" alt="enter image description here">
  but expain is not for update and delete command.<br>
  In php, I want to update an table using a sql , I want to check weather this sql will update only row or many rows , if many rows affected , this sql is not allow to run for  preventing the table misoperation.<br>
  so how can I know how many rows will this update sql affected before I execute it?</p>
  
  <pre><code>update products set products_model = 'hello' where products_id = '1'
  </code></pre>