Re: [sqlite] Joining tables in a single file

2006-12-29 Thread Ken
I think the attach is the way to go, but no need to insert, just select from the attached databases. sqlite3 master.db (master is empty). attach a.db A attach b.db B attach c.db C Then : select from a.A, b.b, c.c where Alberto Simões <[EMAIL PROTECTED]>

Re: [sqlite] Joining tables in a single file

2006-12-29 Thread Alberto Simões
On 12/29/06, Griggs, Donald <[EMAIL PROTECTED]> wrote: Regarding: " I need something like: cat A.db B.db C.db > full.db # kidding" - Hi Alberto, My first inclination is to consider this a classic use of the ATTACH

RE: [sqlite] Joining tables in a single file

2006-12-29 Thread Griggs, Donald
Regarding: " I need something like: cat A.db B.db C.db > full.db # kidding" - Hi Alberto, My first inclination is to consider this a classic use of the ATTACH DATABASE command http://www.sqlite.org/lang_attach.html

[sqlite] Joining tables in a single file

2006-12-29 Thread Alberto Simões
Hi I am using SQLite to store ngrams from texts (bigrams, trigrams and tetragrams). This is not really important for the question; just imagine I have three tables A (int,int), B (int, int, int) and C (int, int, int, int). As the table keys are full rows and the tables get big, it is not quite