Sqlite3 Export into a report

Because the provided program database is hidden from non-programmers, it is necessary to generate a report information for other people to analyze.

. mode Csv.head onselect ...;

It is convenient and practical to export the data of the query to a file and then change the suffix to csv.

In order to figure less code in the program, so write these things into the script as Tmep.sql, and then call Sqlite3 database.db <temp.sql >file.csv

Resolves user data export issues.

Sqlite3 Export into a report