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 <techi...@gmail.com> 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 <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 > -- 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
