Hi All, Thank you so much for your answers.
The Copy command that i have mentioned was found in below link: https://www.sqlite.org/tclsqlite.html#copy But just realized that it is in tcl interface. I overlooked it earlier :( 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. How can i do that? please help. Thanks & Best Regards, - Mahi On Sat, Mar 26, 2016 at 3:52 AM, Domingo Alvarez Duarte < sqlite-mail at dev.dadbiz.es> wrote: > Hello ! > > Have you ever heard about user friendly "alias/shortcut" ? > > Cheers ! > > Fri Mar 25 2016 10:48:52 PM CET from "James K. Lowden" > ><jklowden at schemamania.org> Subject: Re: [sqlite] Help needed for COPY > >Command. > > > > On Fri, 25 Mar 2016 17:18:16 +0100 > > "Domingo Alvarez Duarte" <sqlite-mail at dev.dadbiz.es> 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, but necessary: SQL has no "read from file" feature. > > > > You could have > > > > .export filename tablename > > > > but SQL already has a "read from table" feature, and shell already has > > a "write to file" feature. So an export command would be a redundant > > subset of what's already available. > > > > --jkl > > _______________________________________________ > > sqlite-users mailing list > > sqlite-users at mailinglists.sqlite.org > > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > > > > > > > > > > > > _______________________________________________ > sqlite-users mailing list > sqlite-users at mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users >