On Mon, 5 Jan 2009 10:02:14 -0800, "Webb Sprague" <webb.spra...@gmail.com> wrote in General Discussion of SQLite Database <sqlite-users@sqlite.org>:
> Hi list > > I would like to set my ".mode tabs" and then run a command like so > (yielding output separated by tabs instead of pipes): > > sqlite3 NLSY.db '.mode tabs; select * from DS0001 limit 1;' > > but this doesn't work because the .mode tabs isn't > separated from the regular SQL. > > Could someone point out how to accomplish this? That's a one liner: echo ".mode tabs\nselect * from DS0001 limit 1;" | sqlite3 NLSY.db > THanks so much to a very helpful list! > -W -- ( Kees Nuyt ) c[_] _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
