Anderson, James H (IT) wrote:
I need to "export" a table to a file in the same format as used by
.import, but I don't see any such cmd. Am I missing something, or does
such a cmd just not exist?
jim
You can get csv output from sqlite using the .mode command to specify
the output format and the .output command to set the output file.
.mode csv
.headers on
.output mytable.csv
select * from mytable;
.output stdout
HTH
Dennis Cote
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
