Thank you all for your responses. I'll try your inputs and let me see which
one suits my requirement.
Thanks & Best Regards,
- Mahi
On Mon, Mar 28, 2016 at 6:27 PM, Don V Nielsen
wrote:
> You need to handle the load yourself. Since you are talking bulk load, a
> scripting language is probably
about user friendly "alias/shortcut" ?
>
> Cheers !
> > Fri Mar 25 2016 10:48:52 PM CET from "James K. Lowden"
> > Subject: Re: [sqlite] Help needed for COPY
> >Command.
> >
> > On Fri, 25 Mar 2016 17:18:16 +0100
> > "Domingo Al
On 28 Mar 2016, at 6:49am, Mahi Gurram wrote:
> I have tried .import and its working for command line interface. But i need
> to do a bulk import (copy data from file into table) from c interface.
Sorry, but SQLite has no facilities for handling text files. It reads and
writes to its own data
You need to handle the load yourself. Since you are talking bulk load, a
scripting language is probably out of the question because they are too
slow. I used C# with the System.Data.Sqlite binary.
The db handling you need to worry about is the following:
connection to db
prepare an insert state
Hello !
Have you ever heard about user friendly "alias/shortcut" ?
Cheers !
> Fri Mar 25 2016 10:48:52 PM CET from "James K. Lowden"
> Subject: Re: [sqlite] Help needed for COPY
>Command.
>
> On Fri, 25 Mar 2016 17:18:16 +0100
> "Domingo Al
On Fri, 25 Mar 2016 17:18:16 +0100
"Domingo Alvarez Duarte" wrote:
> Why not have direct command ".export table_name" and internally it
> does all commands you mention in one go, simple and intuitively.
Importing has unique requirements.
.import filename tablename
is quite limited,
uot; command I also expected the "export" command, and it
seems that I'm not alone.
Cheers !
> Fri Mar 25 2016 03:49:37 PM CET from "Simon Slavin"
> Subject: Re: [sqlite] Help needed for COPY Command.
>
> On 25 Mar 2016, at 11:33am, Richard Hipp wrote:
>
Hi,
Good Morning.
I'm trying to use the COPY command but for some reason i'm unable to make
it work.
As per the doc, below is the query syntax:
*copy* *conflict-algorithm* *table-name * *file-name * ?
*column-separator*? ?*null-indicator*?
I have created a file with data and tried a
On 25 Mar 2016, at 11:33am, Richard Hipp wrote:
> On 3/25/16, Simon Slavin wrote:
>
>> There is no COPY command in SQLite.
>
> There *was* a COPY command, way back in SQLite 2.x. It was omitted
> from SQLite3, circa 2004.
Wow.
On 25 Mar 2016, at 12:22pm, Domingo Alvarez Duarte wrote:
> B
Hello !
I also asked the same thing a few days ago and received the same answer.
But discovered that it can be somehow emulated by "import tablename" using
csv.
Would be a good idea to have the complementary of ".import" -> ".export".
Cheers !
Cheers !
?
On 25 Mar 2016, at 10:00am, Mahi Gurram wrote:
> I'm trying to use the COPY command but for some reason i'm unable to make
> it work.
There is no COPY command in SQLite.
> As per the doc, below is the query syntax:
>
> *copy* *conflict-algorithm* *table-name * *file-name * ?
> *column
On 3/25/16, Simon Slavin wrote:
>
> On 25 Mar 2016, at 10:00am, Mahi Gurram wrote:
>
>> I'm trying to use the COPY command but for some reason i'm unable to make
>> it work.
>
> There is no COPY command in SQLite.
There *was* a COPY command, way back in SQLite 2.x. It was omitted
from SQLite3,
12 matches
Mail list logo
