sqlite3 notes

basics

attaching secondary databases

to insert, query, etc. between tables on different databases, attach multiple to your session

sqlite> ATTACH DATABASE file_name AS database_name;

list attached databases

sqlite> .databases
seq  name             file
---  ---------------  ----------------------------------------------------------
0    main             c:\sqlite\db\chinook.db
2    contacts         c:\sqlite\db\contacts.db

How to combine rows based on duplicate data in Sqlite

combine rows android