title: SQL Error Code: 1172 on update not insert
body: <p>I have a very basic query here</p>
  
  <pre><code>UPDATE leads
  SET created = NOW()
  WHERE id IN(
      4142429,
      4142430,
      4142431,
      4142432,
      4142433,
      4142434,
      4142435,
      4142436,
      4142437
  );
  </code></pre>
  
  <p>But whenever i try to run it in sqlYOG, I get the error:</p>
  
  <pre><code>Error Code: 1172
  Result consisted of more than one row
  </code></pre>
  
  <p>I did some research to the error, and that turned up this question:</p>
  
  <p><a href="https://stackoverflow.com/questions/25820109/error-1172-result-consisted-more-than-one-row-in-sql">Error 1172 : Result consisted more than one row (in SQL)</a></p>
  
  <p>which has already been answered, but the answer is not clear. I'm not inserting anything into the table either.</p>
  
  <p>I have also tried doing the query</p>
  
  <pre><code>UPDATE leads SET created = NOW() - INTERVAL 1 DAY WHERE ID = 4142432;
  </code></pre>
  
  <p>But I still get the same error.</p>
  
  <p>Why does this happen when I am only updating one row?</p>