title: MySQL - UPDATE query with LIMIT
body: <p>I want to update rows in my table with starting from 1001 to next 1000.</p>
  
  <p>I tried with following query:</p>
  
  <pre><code>UPDATE `oltp_db`.`users` SET p_id = 3 LIMIT 1001, 1000
  </code></pre>
  
  <ol>
  <li>This is giving me syntax error. Is this correct? am I doing any mistake here.</li>
  <li>Can we limit update in this way?</li>
  </ol>
  
  <p>Also, the rows that I am trying to update are having Null value for the column p_id which is having data type INTEGER. Due to this I am not even able to update using following query:</p>
  
  <pre><code>UPDATE `oltp_db`.`users` SET p_id = 3 WHERE p_id = null
  </code></pre>
  
  <ol>
  <li>Is my above query correct?</li>
  <li>What can be done to achieve this?</li>
  </ol>