title: will limit work same for both condition in select and delete statement
body: <p>i have to pick unused items from a table, move those items with other info to used table that will be called <code>useditems</code>. while items finally moved i have to delete those items from unused table. </p>
  
  <p>so i have write down following query . </p>
  
  <pre><code>INSERT INTO USED select KNumber from unused limit 1000;
  DELETE FROM unused limit 1000;
  </code></pre>
  
  <p>my only concern point is that its always pick the same record as i am not using any order by  in query and in table i have only single column . so only inserted records will be deleted. </p>
  
  <p>i am new with mysql . </p>