Use a Configuration File

You can create a file to set your defaults for the SQLite client in $HOME/.sqliterc

Example:

.headers on
.mode box
.prompt "sqlite> " "   ...> "
.nullvalue "<NULL>"

Other nifty parts for the config file can be found with these resources:

• ”~/.sqliterc” by Kiril Vladimirov
• “Some cool SQLite things” by Ryan Chandler

Resources and References

• StackOverflow: “Change SQLite default settings”
• Official documentation: “Getting Started”