Print column names in SQLite3 output along with query results

Question

When I do this in Android:

sqlite> SELECT * FROM secure WHERE name='mock_location' OR value=2.2 ORDER BY value ASC;

I get this:

44|mock_location|1 56|facelock_liveliness_recognition_threshold|2.2

But I want the column names for (*) in the first row, like this:

_id|name|value 44|mock_location|1 56|facelock_liveliness_recognition_threshold|2.2

How can I do that in a single query?

I can't use Cursor because I am trying to construct the cursor. — JohnyTex
– JohnyTex, Commented May 2, 2017 at 7:09

JohnyTex · Accepted Answer · 2017-05-02 11:38:29Z

I did this and it works:

sqlite3 -header /data/data/com.android.providers.settings/databases/settings.db "SELECT * FROM secure WHERE name='mock_location' OR value=2.2 ORDER BY value ASC;"

Collectives™ on Stack Overflow

Print column names in SQLite3 output along with query results

1 Answer 1

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Linked

Related