Re: [sqlite] Importing table

2008-06-17 Thread Jim Dodgen
don't forget to wrap inserts in begin; commit; pairs On 6/17/08, Dennis Cote <[EMAIL PROTECTED]> wrote: > Alberto Simões wrote: > > > > I have a text file with 18 399 392 lines. Each line contains five > > fields. Four are a compound key, the other is just data. > > What is the best way to

Re: [sqlite] Importing table

2008-06-17 Thread Dennis Cote
Alberto Simões wrote: > > I have a text file with 18 399 392 lines. Each line contains five > fields. Four are a compound key, the other is just data. > What is the best way to import this to sqlite? > > I am thinking on creating another text file with 18 399 392 INSERT commands. > Would that

Re: [sqlite] Importing table

2008-06-17 Thread Alberto Simões
On Tue, Jun 17, 2008 at 6:33 PM, P Kishor <[EMAIL PROTECTED]> wrote: > On 6/17/08, Alberto Simões <[EMAIL PROTECTED]> wrote: >> Hi, Folks >> I am thinking on creating another text file with 18 399 392 INSERT >> commands. >> Would that be the best method? > > Look at the .read command in the

Re: [sqlite] Importing table

2008-06-17 Thread P Kishor
On 6/17/08, Alberto Simões <[EMAIL PROTECTED]> wrote: > Hi, Folks > > I have a text file with 18 399 392 lines. Each line contains five > fields. Four are a compound key, the other is just data. > What is the best way to import this to sqlite? > > I am thinking on creating another text file

[sqlite] Importing table

2008-06-17 Thread Alberto Simões
Hi, Folks I have a text file with 18 399 392 lines. Each line contains five fields. Four are a compound key, the other is just data. What is the best way to import this to sqlite? I am thinking on creating another text file with 18 399 392 INSERT commands. Would that be the best method? (by