Thanks!
-Original Message-
From: jphillip [mailto:[EMAIL PROTECTED]
Sent: Tuesday, December 19, 2006 4:24 PM
To: sqlite-users@sqlite.org
Subject: RE: [sqlite] Is there a method for doing bulk insertion?
issue .help
look for .separator
example for a csv file with colon(:) separators
e's no way to use a delimiter other than a
> comma to import a CSV file?
>
> -Original Message-
> From: jphillip [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, December 19, 2006 3:47 PM
> To: sqlite-users@sqlite.org
> Subject: RE: [sqlite] Is there a method for doing
Thanks!
-Original Message-
From: Jeff Godfrey [mailto:[EMAIL PROTECTED]
Sent: Tuesday, December 19, 2006 4:01 PM
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] Is there a method for doing bulk insertion?
Take a look at the ".separator" command. It seems to be what
Take a look at the ".separator" command. It seems to be what you
need...
Jeff
- Original Message -
From: "Anderson, James H (IT)" <[EMAIL PROTECTED]>
To:
Sent: Tuesday, December 19, 2006 2:52 PM
Subject: RE: [sqlite] Is there a method for doing bulk in
] [mailto:[EMAIL PROTECTED]
> Sent: Monday, December 18, 2006 9:12 AM
> To: sqlite-users@sqlite.org
> Subject: Re: [sqlite] Is there a method for doing bulk insertion?
>
> "Anderson, James H \(IT\)" <[EMAIL PROTECTED]> wrote:
> > or do I have to creation a g
ilto:[EMAIL PROTECTED]
> Sent: Monday, December 18, 2006 9:12 AM
> To: sqlite-users@sqlite.org
> Subject: Re: [sqlite] Is there a method for doing bulk insertion?
>
> "Anderson, James H \(IT\)" <[EMAIL PROTECTED]> wrote:
> > or do I have to creation a gazillio
How do I find doc on .import?
Is there a way to specify the delimiter for the CSV file?
Thanks,
jim
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Monday, December 18, 2006 9:12 AM
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] Is there a method for
Thanks.
-Original Message-
From: Jay Sprenkle [mailto:[EMAIL PROTECTED]
Sent: Monday, December 18, 2006 8:32 PM
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] Is there a method for doing bulk insertion?
On 12/18/06, Anderson, James H (IT) <[EMAIL PROTECTED]>
wrote:
> I w
On 12/18/06, Anderson, James H (IT) <[EMAIL PROTECTED]> wrote:
I was hoping there was the equivalent of Sybase's BCP program. I was
also hoping something programmatic was available, i.e., not something
from the command shell. Maybe a little background would help.
I'm planning on using the perl p
conversion, nor do I
> want to shell out of the code to invoke this.
>
> jim
>
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
> Sent: Monday, December 18, 2006 9:12 AM
> To: sqlite-users@sqlite.org
> Subject: Re: [sqlite] Is there a
AIL PROTECTED]
Sent: Monday, December 18, 2006 9:12 AM
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] Is there a method for doing bulk insertion?
"Anderson, James H \(IT\)" <[EMAIL PROTECTED]> wrote:
> or do I have to creation a gazillion insert statements?
>
The
"Anderson, James H \(IT\)" <[EMAIL PROTECTED]> wrote:
> or do I have to creation a gazillion insert statements?
>
The sqlite3 command-line shell has a ".import" command which
can be used to read CSV data. But the way this works internally
is that the command-line shell constructs an INSERT s
...or do I have to creation a gazillion insert statements?
Thanks,
jim
NOTICE: If received in error, please destroy and notify sender. Sender does not
intend to waive confidentiality or privilege. Use of this email is prohibited
when rec
13 matches
Mail list logo
