We often use Excel in data processing domain, and today I will share with you an Excel cheat sheet.
It’s very simple:
sqlite> .mode list
sqlite> .separator ,
sqlite> .output exported_file.csv
sqlite> select * from yourtable;
You can use other separator. For Microsoft Excel default separator is “;”.