Sqlite3 output to .csv
Every now and then I'm in need of exporting some data from an SQLite3 database to .csv
. And every time i just end up looking it up on the internet.
Below is just a quick snippet of outputting a query to a .csv
file,
.headers on
.mode csv
.separator ;
.output filename.csv
select * from something;
.output stdout
And that's it :)