On Tue, 18 Dec 2007 09:58:55 -0800 (PST), Joanne Pham <[EMAIL PROTECTED]> wrote:
>Hi All, >Is there any way that we can export the data to CSV format to the disk. >Thanks, >Joanne I wonder what you tried yourself. Oh, well. sqlite3 mydb SQLite version 3.5.4 Enter ".help" for instructions sqlite> .mode csv sqlite> .output filename.ext sqlite> SELECT * FROM tablename; sqlite> .q HTH -- ( Kees Nuyt ) c[_] ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
