How to write sqlite3 output to bash variable?

Question

linux

I want to write the output of sql3 to a shell variable in the provided script.

#!/bin/sh

sqlite3 test.db <<EOF
create table n (id INTEGER PRIMARY KEY,f TEXT,l TEXT);
insert into n (f,l) values ('john','smith');
select * from n;
EOF

exit 0;

How can I do it?

Answer 1

Like this for example:

#!/bin/sh

output=`sqlite3 test.db <<EOF
create table n (id INTEGER PRIMARY KEY,f TEXT,l TEXT);
insert into n (f,l) values ('john','smith');
select * from n;
EOF`
echo $output
exit 0;