Hi,
Since I don't find a command that can directly export the data into a
file, I use pipe to export data from sqlite3 to a tsv file. Is there a
better way to do so?
$ cat main.sh
#!/usr/bin/env bash
rm -rf main.db3
sqlite3 main.db3 '.read main.sql' > main.txt
$ cat main.sql
create table A (name text, position integer);
insert into A values('a', 1);
insert into A values('b', 10);
.separator ','
select * from A;
$ ./main.sh
$ cat main.txt
a,1
b,10
--
Regards,
Peng
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
