Re: [sqlite] SQlite3 Query Format for Export

2013-11-19 Thread Kees Nuyt
On Tue, 19 Nov 2013 19:05:55 +0530, techi eth wrote: >I need this often. > >If possible provide some hint of plugin in Linux platform. > >Thanks Have a look at the sqlite3 command line tool: sqlite3 -help and at the .help command in that same command line tool. Of interest are e.g. : .separato

Re: [sqlite] SQlite3 Query Format for Export

2013-11-19 Thread John McKown
You might see if the following looks like it would work for you. This is from the BASH command prompt: echo '.dump' | sqlite3 mydatabase.sqlite3 >mydatabase.sql On Tue, Nov 19, 2013 at 7:35 AM, techi eth wrote: > I need this often. > > If possible provide some hint of plugin in Linux platfor

Re: [sqlite] SQlite3 Query Format for Export

2013-11-19 Thread Hick Gunter
13 14:36 An: R Smith; General Discussion of SQLite Database Betreff: Re: [sqlite] SQlite3 Query Format for Export I need this often. If possible provide some hint of plugin in Linux platform. Thanks On Tue, Nov 19, 2013 at 7:01 PM, RSmith wrote: > > What will be the query format to expor

Re: [sqlite] SQlite3 Query Format for Export

2013-11-19 Thread techi eth
I need this often. If possible provide some hint of plugin in Linux platform. Thanks On Tue, Nov 19, 2013 at 7:01 PM, RSmith wrote: > > What will be the query format to export database table data into different >> export format (CSV,HTML,XML,SQL) ? >> >> > This is not an SQL function. > > Do

Re: [sqlite] SQlite3 Query Format for Export

2013-11-19 Thread RSmith
What will be the query format to export database table data into different export format (CSV,HTML,XML,SQL) ? This is not an SQL function. Do you need it exported to some format once, or do you need this often (such as providing it as a standard functionality to users?) If you need it once

[sqlite] SQlite3 Query Format for Export

2013-11-19 Thread techi eth
Hi, What will be the query format to export database table data into different export format (CSV,HTML,XML,SQL) ? Thanks ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users