I need to move data from one table to another in my Android app I would like to use the following sql: Unfortunately in table MYTABLE2 there is an _ID column AUTOINCREMENT. What could I do? Thanks. EDIT: this is my MYTABLE2 the, the table I would like to populate with data from another table: Answer explicitly specify the column