Move data to a new table

Reference

To move data from one table to another INSERT into the new one by SELECTing from the old one.

BEGIN TRANSACTION;
 
INSERT INTO Table1 (<columns>)
SELECT <columns>
FROM Table2
WHERE <condition>;
 
DELETE FROM Table1
WHERE <condition>;
 
COMMIT;