sqlite3 app.db '.nullvalue NULL'

Category: Databases & SQL

sqlite3 app.db '.nullvalue NULL'

Show NULLs as a readable marker

NULL displays as an empty string by default, which is easy to mistake for a value; .nullvalue NULL makes it visible. Related: .headers on.
Looking for more? Search all 7,657 commands — works offline, in English or Spanish, and fixes typos.