Re: [sqlite] "meta command" via string via shell?

On Mon, 5 Jan 2009 10:02:14 -0800, "Webb Sprague" wrote in General Discussion of SQLite Database : > 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

Re: [sqlite] "meta command" via string via shell?

...@gmail.com] Sent: Monday, January 05, 2009 12:45 PM To: General Discussion of SQLite Database Subject: Re: [sqlite] "meta command" via string via shell? > If I understand correctly, all you need to do is write the desired > commands out to a text file, then either direct stdin t

Re: [sqlite] "meta command" via string via shell?

I've been using SQLite for about 5 years now, and the "put the commands in a file" is the best answer I'm aware of. -T On Mon, Jan 5, 2009 at 1:44 PM, Webb Sprague wrote: >> If I understand correctly, all you need to do is write the desired >> commands out to a

Re: [sqlite] "meta command" via string via shell?

> If I understand correctly, all you need to do is write the desired > commands out to a text file, then either direct stdin to the text file, > or use the '.read" command. Yes, I could write the commands out to a file (ick!), but I don't really want to add four lines and a whole lot of I/O. I

Re: [sqlite] "meta command" via string via shell?

Regarding: "...but this doesn't work because the .mode tabs isn't separated from the regular SQL. Could someone point out how to accomplish this?" If I understand correctly, all you need to do is write the desired commands out to a text file, then either direct stdin to the text file, or

[sqlite] "meta command" via string via shell?

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