Sqlite | Merge rows from two identical db files
mouse 1821 · person cloud · link
DB
Dev
HowTo
Sqlite
Last update
2016-12-15
2016
12-15
« — » 
1
2
3
ATTACH 'file.sqlite3' AS secondary;
PRAGMA database_list; -- show attached databases
INSERT OR IGNORE INTO main.table_name SELECT * FROM secondary.table_name;