Am 6.8.05 um 09:06 schrieb Joe Noon:
You can use a system call to execute a command like the following;
sqlite3 -separator , test.db ".import test.csv sometable"
That is exactly what I needed! Thanks a ton.
Joe Noon
My issue now is that the csv may or may not have all of the columns
> > You can use a system call to execute a command like the following;
> >
> > sqlite3 -separator , test.db ".import test.csv sometable"
> >
>
> That is exactly what I needed! Thanks a ton.
>
> Joe Noon
>
My issue now is that the csv may or may not have all of the columns
that my table has.
> You can use a system call to execute a command like the following;
>
> sqlite3 -separator , test.db ".import test.csv sometable"
>
That is exactly what I needed! Thanks a ton.
Joe Noon
Dear all,
> You can use a system call to execute a command like the following;
>
> sqlite3 -separator , test.db ".import test.csv sometable"
I do something very similar to this from a Perl application for speed.
It's about twice as fast as doing this from DBI. (Benchmarked on very
large files).
Joe Noon wrote:
Id like to import a csv, comma delimited file, into a table (sqlite3
db) in my Ruby application. I can do it either of three ways:
1.) With a SQL statement like the COPY command. Ive read this was
taken out, but then found a place that said it has been reimplemented?
Ive had
Can you write C?
Steal the code from the sqlite command line tool source. :)
On 8/5/05, Joe Noon <[EMAIL PROTECTED]> wrote:
> Id like to import a csv, comma delimited file, into a table (sqlite3
> db) in my Ruby application. I can do it either of three ways:
>
Id like to import a csv, comma delimited file, into a table (sqlite3
db) in my Ruby application. I can do it either of three ways:
1.) With a SQL statement like the COPY command. Ive read this was
taken out, but then found a place that said it has been reimplemented?
Ive had no luck with
7 matches
Mail list logo