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 :)