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