First we will open up our database.
Then set the mode to CSV and turn on our headers.
.mode csv .headers on
Then we will set the output file.
And finally, we will get our data to export.
SELECT * FROM
If we exit sqlite, we will see our output file in the current working directory. We can then cat out the file and see the data from our table.