RE: [sqlite] Is there a method for doing bulk insertion?

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

RE: [sqlite] Is there a method for doing bulk insertion?

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 bulk insertion?

RE: [sqlite] Is there a method for doing bulk insertion?

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

Re: [sqlite] Is there a method for doing bulk insertion?

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: <sqlite-users@sqlite.org> Sent: Tuesday, December 19, 2006 2:52 PM Subject: RE: [sqlite]

RE: [sqlite] Is there a method for doing bulk insertion?

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 gazill

RE: [sqlite] Is there a method for doing bulk insertion?

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 gazill

RE: [sqlite] Is there a method for doing bulk insertion?

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

RE: [sqlite] Is there a method for doing bulk insertion?

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

Re: [sqlite] Is there a method for doing bulk insertion?

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

RE: [sqlite] Is there a method for doing bulk insertion?

: 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 sqlite3 command-lin

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