SQLite Database - How to retrieve from SQL database without showing the column title?

I am able to retrieve a value stored in a SQLite database. But the value retrieved shows up with the title of the column followed by the value stored in the column. I would like to retrieve the value stored but without showing the column. Does anyone know how to do that?

sqlite> .headers off
sqlite> SELECT name FROM table;

this depends on the sqlite extension you are using...
for my sqlite extension you just can set the property IgnoreHeader to true
setIgnoreHeader

https://puravidaapps.com/sqlite.php

Taifun


Trying to push the limits! Snippets, Tutorials and Extensions from Pura Vida Apps by Taifun.

1 Like