Can I make this a One-liner solution with ADB or Windows Batch?

Question

Can I get those three lines in a one-liner solution from windows cmd or in a windows batch file ?

adb shell
sqlite3 /data/data/my.package.name/databases/myDb.db
SELECT value1, value2 FROM Table1;

I was thinking this is it; but i can't figure how to write it exactly

adb shell sqlite3 /data/data/my.package.name/databases/myDb.db | SELECT value1, value2 FROM Table1;

When I use **&&** it shows **sqlite>** but I can't type anyting — M. A., Nov 25 '16 at 23:20
when using the three commands separately, they work normally. — M. A., Nov 25 '16 at 23:21
Did not tell you to use &&. I do not know how your programs work. I just know that if you want all commands on one line at the cmd prompt or a batch file you use the ampersand. — Squashman, Nov 25 '16 at 23:23
@AbdelhafidMadoui - the android shell command for `sqlite3` is the same regardless of the scripting language used on the host PC — Alex P., Nov 25 '16 at 23:31
I could have linked to http://stackoverflow.com/a/16851992/1778421 instead. Either way your question is a clear duplicate — Alex P., Nov 25 '16 at 23:33
yes it's a duplicate for your solution found on http://stackoverflow.com/a/16851992/1778421 — M. A., Nov 25 '16 at 23:43
So this question was improperly tagged with the batch-file and cmd tags. — Squashman, Nov 26 '16 at 17:00

Alex P. · Accepted Answer · 2016-11-25T23:33:57.060

1

Assuming your phone is rooted (or has engineering build loaded):

adb shell "sqlite3 /data/data/my.package.name/databases/myDb.db 'SELECT value1, value2 FROM Table1;'"

Because otherwise shell user will not have access to /data/data/my.package.name/

edited Nov 25 '16 at 23:33

answered Nov 25 '16 at 23:30

Alex P.

1 Answers1