issue .help look for .separator example for a csv file with colon(:) separators issue .separator ':'
use an editor to change the existing separator character(s) to the character you want to use. On Tue, 19 Dec 2006, Anderson, James H (IT) wrote: > So I can assume that there'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 bulk insertion? > > > > .help pretty well sums it up. > > On Tue, 19 Dec 2006, Anderson, James H (IT) wrote: > > > 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 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 statement, > > parses each line of the CSV file and binds the values to that > > INSERT statement, then runs the INSERT statement for each line. > > So at the end of the day, a bunch of INSERT statements are still > > getting evaluated - you just don't see them. > > > > On my workstation, an INSERT statement can be parsed, compiled, > > and evaluated in 25-40 microseconds. That's about 30000 rows > > per second. How much performance do you need? > > > > -- > > D. Richard Hipp <[EMAIL PROTECTED]> > > > > > > > ------------------------------------------------------------------------ > > ----- > > To unsubscribe, send email to [EMAIL PROTECTED] > > > ------------------------------------------------------------------------ > > ----- > > -------------------------------------------------------- > > > > 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 received in error. > > > > > ------------------------------------------------------------------------ > ----- > > To unsubscribe, send email to [EMAIL PROTECTED] > > > ------------------------------------------------------------------------ > ----- > > > > > > You have to be BRAVE to grow OLD. > There are no old CARELESS pilots or electricians. > > > ------------------------------------------------------------------------ > ----- > To unsubscribe, send email to [EMAIL PROTECTED] > ------------------------------------------------------------------------ > ----- > -------------------------------------------------------- > > 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 received in error. > > ----------------------------------------------------------------------------- > To unsubscribe, send email to [EMAIL PROTECTED] > ----------------------------------------------------------------------------- > > You have to be BRAVE to grow OLD. There are no old CARELESS pilots or electricians. ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
