SQLite Select command in bash

Question

I'm having trouble with my SQLite Select called from a bash script. I'm trying to get a single value from myDB.db and store it to the variable "result".

result=sqlite3 /media/0CBA-1996/logfiles/SQLite3Database/myDB.db "SELECT energy FROM SmartMeter WHERE Timestamp= date('now') LIMIT 1";

echo $result

The problem seems to be with the quotations cause when I leave out "WHERE Timestamp= date('now')" I get a return from the database.

Any ideas ? Thanks Mick

if it was the quotes, then a simple select date('now') would also fail. — Marc B
– Marc B, Commented Mar 3, 2014 at 20:17

RobbySherwood · Accepted Answer · 2014-03-03 20:19:59Z

8

normally you want the OUTPUT to become the variables value:

result=$(sqlite3 /media/0CBA-1996/logfiles/SQLite3Database/myDB.db "SELECT energy FROM SmartMeter WHERE Timestamp= date('now') LIMIT 1")

echo $result

you nee to use $() or `` like this

result=`sqlite3 /media/0CBA-1996/logfiles/SQLite3Database/myDB.db "SELECT energy FROM SmartMeter WHERE Timestamp= date('now') LIMIT 1" `

echo $result

answered Mar 3, 2014 at 20:19

RobbySherwood

3612 silver badges8 bronze badges

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

Collectives™ on Stack Overflow

SQLite Select command in bash

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related