Re: [sqlite] Exporting database to CSV file

2009-01-07 Thread Brandon, Nicholas (UK)
. > > Is there a way to do this entirely through php? I would like > to make a query on a table and write the results to a csv > file so that the user can have the option of downloading it. > Has anyone ever done something similar to this? > > Thanks > I believe there is a function like '

Re: [sqlite] Exporting database to CSV file

2009-01-07 Thread Jonathon
Thanks for the replies... Actually, it seems my requirements have changed.. Is there a way to do this entirely through php? I would like to make a query on a table and write the results to a csv file so that the user can have the option of downloading it. Has anyone ever done something similar t

Re: [sqlite] Exporting database to CSV file

2009-01-06 Thread Alexey Pechnikov
Hello! В сообщении от Tuesday 06 January 2009 15:33:42 Sylvain Pointeau написал(а): > The import has the big limitation to not be able to import the file when a > field is on multiple lines.I don't know if this is the same for the > export... See virtualtext extension from spatialite project. Be

Re: [sqlite] Exporting database to CSV file

2009-01-06 Thread Sylvain Pointeau
The import has the big limitation to not be able to import the file when a field is on multiple lines.I don't know if this is the same for the export... Cheers, Sylvain On Tue, Jan 6, 2009 at 11:08 AM, MikeW wrote: > Jonathon writes: > > > > > Awesome. Thanks for the quick reply Deech :) > >

Re: [sqlite] Exporting database to CSV file

2009-01-06 Thread MikeW
Jonathon writes: > > Awesome. Thanks for the quick reply Deech :) > > J "Awesome" ? You must be easily impressed/scared ! ;-) MikeW ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Exporting database to CSV file

2009-01-05 Thread Jonathon
Awesome. Thanks for the quick reply Deech :) J On Mon, Jan 5, 2009 at 2:34 PM, aditya siram wrote: > 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 wrote: > > > H

Re: [sqlite] Exporting database to CSV file

2009-01-05 Thread aditya siram
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 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

[sqlite] Exporting database to CSV file

2009-01-05 Thread Jonathon
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 __