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
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
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
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
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
5 matches
Mail list logo