title: sqlite insert into table select * from
body: <p>I need to move data from one table to another in my Android app</p>
  
  <p>I would like  to use the following sql:</p>
  
  <pre><code>insert into MYTABLE2 select id, STATUS risposta, DATETIME('now') data_ins from  MYTABLE 2
  </code></pre>
  
  <p>Unfortunately in table MYTABLE2  there is an _ID column AUTOINCREMENT.
  What could I do?</p>
  
  <p>Thanks.</p>
  
  <p><strong>EDIT:</strong> 
  this is my MYTABLE2 the, the table I would like to populate with data from another table:</p>
  
  <pre><code>CREATE TABLE "ANSWERS" ("_id" INTEGER PRIMARY KEY  AUTOINCREMENT  NOT NULL ,
  "ID_QUESTION" INTEGER,"DATE_INS" DATETIME DEFAULT 
  (CURRENT_DATE) , "ANSWER" INTEGER)
  </code></pre>