View source for 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

==copying data==
===between columns===
===between tables===
===between databases===

==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==

[http://stackoverflow.com/questions/32369323/android-how-to-combine-rows-based-on-duplicate-data-in-sqlite combine rows android]