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

2

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;"

answered May 2, 2017 at 11:38

JohnyTex

3,4915 gold badges32 silver badges57 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Print column names in SQLite3 output along with query results

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related