title: mysql : Can't find record in table
body: <p>In my java program an update query is used like below,</p>
  
  <pre><code>update unsub_tbl set stat=1 where stat=0 and emp_id='4441' and action='1';
  </code></pre>
  
  <p>if <code>unsub_tbl</code> is empty, then trying to update using above update query gives exception:</p>
  
  <blockquote>
    <p>java.sql.SQLException: Can't find record in 'unsub_tbl'</p>
  </blockquote>
  
  <p>But it's not giving the exception all the time for same condition. Why does it only give the exception sometimes?</p>