SQLite Forum

Update table from SQLite3 queries results.
Login
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.