If there are views and triggers and whatnot attached to the table, that might not work so well. In which case, make Table2 temporary, and after populating it, ``` BEGIN; DELETE FROM Table1; INSERT INTO Table1 SELECT * FROM Table2; END; ``` The transaction is just to recover in case of a crash or power loss.