how to run sqlite3 in bash script?

Question

I'd like to run series of sqlite commands in bash script:

db="main.sqlite3"
db2="sub.sqlite3"

sqlite3 ${db} <<EOF
attach ${db2} as m;
select count(*) from m.details;
.exit
EOF

when attach to a string, it works, but when it is a variable, it won't, got

Error: near line 1: near "/": syntax error

how to use a variable(db2) inside EOF? thanks

This should work as written. There is no / in the snippet you posted, so maybe you simplified it too much? — Thomas
– Thomas, Commented Aug 15, 2017 at 8:27
I suggest to check your file for special characters: cat -A file or cat -v file — Cyrus
– Cyrus, Commented Aug 15, 2017 at 8:27
Does the attach statement require the dbname to be quoted? Do you need attach '$db2' as m; ?? I can't tell from sqlite.org/syntax/attach-stmt.html and sqlite.org/syntax/expr.html — glenn jackman
– glenn jackman, Commented Aug 15, 2017 at 11:51
finally, that's the one works: sqlite3 ${db} <<EOF attach '${db2}' as m; select count(*) from m.details; .exit EOF — AngeloC
– AngeloC, Commented Aug 15, 2017 at 13:30

Murphy · Accepted Answer · 2017-08-16 12:56:29Z

3

Try putting the DB file to attach into double quotes:

attach "${db2}" as m;

answered Aug 16, 2017 at 12:56

Murphy

4,0194 gold badges23 silver badges36 bronze badges

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

1 Answer 1