Re: [sqlite] SQlite3 Query Format for Export

[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. :
.separator
.mode

With .mode list , combined with SELECT and || concatenation, almost
anything can be done.

SELECT 
 '{"' || firstname || '"'
, '"' || lastname  || '"'
, empnumber
, 
, '"' || country   || '"}'
FROM .

I use .mode line sometimes, which is easy to postprocess,
or .mode list with .separator '\001', if the data is suitable.

-- 
Groet, Cordialement, Pozdrawiam, Regards,

Kees Nuyt

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQlite3 Query Format for Export

[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 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 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, simply download one of the SQLite DB Managers that
> > offers exporting. If you need it often, I'm afraid you will need to make
> > the converters yourself or use some third-party plug-ins that can do it
> for
> > the platform you are designing on.
> >
> >
> > ___
> > sqlite-users mailing list
> > sqlite-users@sqlite.org
> > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
> >
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>



-- 
This is clearly another case of too many mad scientists, and not enough
hunchbacks.

Maranatha! <><
John McKown
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQlite3 Query Format for Export

[Hick Gunter]

Try writing a virtual table module that writes the format you require. E.g.

Create virtual table export using export ('','');
Insert into export select  from ;

-Ursprüngliche Nachricht-
Von: techi eth [mailto:techi...@gmail.com]
Gesendet: Dienstag, 19. November 2013 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 <rsm...@rsweb.co.za> 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 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, simply download one of the SQLite DB Managers
> that offers exporting. If you need it often, I'm afraid you will need
> to make the converters yourself or use some third-party plug-ins that
> can do it for the platform you are designing on.
>
>
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users


--
 Gunter Hick
Software Engineer
Scientific Games International GmbH
Klitschgasse 2 – 4, A - 1130 Vienna, Austria
FN 157284 a, HG Wien
Tel: +43 1 80100 0
E-Mail: h...@scigames.at

This e-mail is confidential and may well also be legally privileged. If you 
have received it in error, you are on notice as to its status and accordingly 
please notify us immediately by reply e-mail and then delete this message from 
your system. Please do not copy it or use it for any purposes, or disclose its 
contents to any person as to do so could be a breach of confidence. Thank you 
for your cooperation.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQlite3 Query Format for Export

[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 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, simply download one of the SQLite DB Managers that
> offers exporting. If you need it often, I'm afraid you will need to make
> the converters yourself or use some third-party plug-ins that can do it for
> the platform you are designing on.
>
>
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQlite3 Query Format for Export

[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, simply download one of the SQLite DB Managers that offers exporting. If you need it often, I'm afraid you will 
need to make the converters yourself or use some third-party plug-ins that can do it for the platform you are designing on.



___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] SQlite3 Query Format for Export

[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