BASH - Export SQLite to CSV - Example

sqlite2csv.sh

#!/bin/bash
# Export SQLite to CSV - Example
# Replace "$database" and "$table"

sqlite3 $database <<!
.headers on
.mode csv
.output $database.csv
select * from $table;
!