-----Original Message-----
From: sqlite-users-boun...@sqlite.org
[mailto:sqlite-users-boun...@sqlite.org] On Behalf Of BOB_GOREN
Sent: Tuesday, March 24, 2009 10:49 AM
To: sqlite-users@sqlite.org
Subject: [sqlite] Replacement for COPY
Sqlite 2.8.13 supported statements like:
COPY ar FROM xxx.odb USING DELIMITERS |
What is the equivalent in sqlite 3.6.11?
COPY seems to no longer be supported - the same statement that works on
2.8 now generates a syntax error and COPY and DELIMITERS are not in the
list of keywords for 3.6.
==================================
Hi Bob,
I found this page: http://www.hwaci.com/sw/sqlite/lang_copy.html
which directs developers to the ".import" command within the sqlite3
command-line utility.
If you must have this capability in your code (versus the standalone
utility) then you might want to look at the source for ".import"
Alternatively, you might want to seek out some good routines in your
language of choice for handling delimited text. The easy "trick" to
quick imports, as you're probably already aware, will be to combine many
or all of your sql INSERTS within a transaction.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
