How to efficiently copy row data from one Table to another in SQLite android

Question

Hello, how do i efficiently copy a row data from one table to another table, where both of them are the same structure. i could go the much harder way of retrieving initial values from the row in the first table and then inserting to the second table. But i feel there is a more efficient way this can be done. Thank you

Answer 1

insert into table1 select * from table2