Try writing a virtual table module that writes the format you require. E.g.
Create virtual table export using export ('<field_list>','<file_name>'); Insert into export select <field_list> from <your table>; -----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