Created: 2022-02-08 22:29
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;