Open the sqlite database using: > sqlite3 database.sqlite >> .mode csv >> .output yourfilename >> your-sql -query
-deech On Mon, Jan 5, 2009 at 4:21 PM, Jonathon <[email protected]> wrote: > Hello all, > > I am interested in exporting a particular table to a CSV file. I've > browsed > google for a bit, but all I could find is third party programs. I was > hoping this functionality was provided in sqlite and that it was super > duper > fast :) > > Thanks! > > J > _______________________________________________ > sqlite-users mailing list > [email protected] > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
