SQLite Forum

"headers on" yet no headers
Login
The behavior you would prefer is my preference also. But the CLI shell does not work that way. The changes necessary to make do so are not well localized in the code. A callback scheme is used to emit the data, and some of them emit a header also for the first row. But with an empty result set, nothing is emitted. 

Several years ago, I suggested changes to "fix" this, without visible effect.