title: Copy column data from one table to another in SQLite
body: <p>I have a table where I need to have a _id column which is incremented. However I cannot use autoincrement due to the table having 3 primary keys. This is in SQLite, btw. The table is already populated with data and therefore I cannot just recreate the table.</p>
  
  <p>Is there a way to insert values from 1 to 148 in the _id column? </p>
  
  <p>We've already tried something like this:</p>
  
  <pre><code>UPDATE table1
  SET _id = (SELECT _id FROM table2)
  </code></pre>
  
  <p>table2 is a temp table which contains the values from 1 to 148. However this just updates all _id values to '1'..</p>
  
  <p>Any suggestions on how to solve this?</p>