从
fine manual:
INIT FILE
sqlite3 reads an initialization file to set the configuration of the interactive environment.
[…]
If the file~/.sqliterc
exists,it is processed first. can be found in the user’s home directory,it is read and processed. It should generally only contain Meta-commands.
所以只需将一个名为.sqliterc的文件放在你的主目录中,并将其放在其中:
.headers ON