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

usefull techniques

helps you prevent an error of creating something that already exists

IF NOT EXISTS

How to combine rows based on duplicate data in Sqlite

combine rows android