Change SQLite default settings

Put:

.headers on
.mode column

In a file called .sqliterc in the home directory of the user running sqlite.

(P.S. I found that in man sqlite3.)

Make sure using the following command to open the file:

nano ~/.sqliterc

then add

.headers on
.mode column

to the file and save it