title: php sql - Understanding You can't specify target table for update in FROM clause
body: <p>I know this question has been posted many times ! but even by reading it I really don't understand it "You can't specify target table for update in FROM clause"</p>
  
  <p>So from what I understand its possible to make a temp table but how or where to make the code I don't understand so I hope you can help with this.</p>
  
  <p>the code is the following</p>
  
  <pre><code>mysql_query("UPDATE infor SET isCount = isCount + 1 WHERE isCount=(select min(isCount) from infor) ") or die(mysql_error());
  </code></pre>
  
  <p>so I already using the table in a SELECT so how can I update this how to understand the workaround 
  as you can see I want to update a table_field that has the lowest value in a column so as I understand I have to workaround the last code after the WHERE right? I tried many things but still nothing
  Hope you can help</p>