If you need to redirect the output of
SQL commands to a
file while using
SQLite, you can do so using the .output command. E.g., I have
an SQLite database on my MacBook Pro laptop running
OS X that
contains a table named Equipment. Within that table is a column named Device
that is a description for the particular piece of equipment in the
table entry. I can view just that field for all records with the
SQLite command SELECT Device FROM Equipment. To direct
the output of the command to a text file named device.txt,
I can use the command .output device.txt. After executing
the command to select the Device field from all records, I can then
issue the .output command without any arguments to it to
return to having the output of commands displayed on the console rather
than going to the file.
$ sqlite3 ~/Documents/Work/CRQ/CRQ.db SQLite version 3.8.10.2 2015-05-20 18:17:19 Enter ".help" for usage hints. sqlite> .output device.txt sqlite> SELECT Device FROM Equipment; sqlite> .output sqlite>
