Thanks! It works.
Joanne
----- Original Message ----
From: Kees Nuyt <[EMAIL PROTECTED]>
To: sqlite-users@sqlite.org
Sent: Tuesday, December 18, 2007 10:23:35 AM
Subject: Re: [sqlite] Re: Error in SQLite's CSV output
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]
-----------------------------------------------------------------------------
____________________________________________________________________________________
Never miss a thing. Make Yahoo your home page.
http://www.yahoo.com/r/hs
