[sqlite] Help needed for COPY Command.

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

[sqlite] Help needed for COPY Command.

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 > > "Domin

[sqlite] Help needed for COPY Command.

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

[sqlite] Help needed for COPY Command.

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

[sqlite] Help needed for COPY Command.

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

[sqlite] Help needed for COPY Command.

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

[sqlite] Help needed for COPY Command.

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

[sqlite] Help needed for COPY Command.

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

[sqlite] Help needed for COPY Command.

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

[sqlite] Help needed for COPY Command.

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 ! ?

[sqlite] Help needed for COPY Command.

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 * ? >

[sqlite] Help needed for COPY Command.

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,