RE: [sqlite] executing sql on a sqlite from the cmd line

"). -dave -Original Message- From: Joe Wilson [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 22, 2007 2:48 PM To: sqlite-users@sqlite.org Subject: RE: [sqlite] executing sql on a sqlite from the cmd line --- "Gauthier, Dave" <[EMAIL PROTECTED]> wrote: > Bu

RE: [sqlite] executing sql on a sqlite from the cmd line

--- "Gauthier, Dave" <[EMAIL PROTECTED]> wrote: > But how can I ".mode column" and ".header on" as well as run the query If you're using bash (ksh and sh might work as well): $ echo -e ".header on\n.mode column\nselect * from sqlite_master;" | ./sqlite3 abc.db typenametbl_name

RE: [sqlite] executing sql on a sqlite from the cmd line

-- From: James Dennett [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 22, 2007 12:04 PM To: sqlite-users@sqlite.org Subject: RE: [sqlite] executing sql on a sqlite from the cmd line > -Original Message- > From: Gauthier, Dave [mailto:[EMAIL PROTECTED] > Sent: Wednesday, Aug

RE: [sqlite] executing sql on a sqlite from the cmd line

> -Original Message- > From: Gauthier, Dave [mailto:[EMAIL PROTECTED] > Sent: Wednesday, August 22, 2007 8:10 AM > To: sqlite-users@sqlite.org > Subject: [sqlite] executing sql on a sqlite from the cmd line > > On Linux... > > > > How can I execute

Re: [sqlite] executing sql on a sqlite from the cmd line

On Wed, 22 Aug 2007, Gauthier, Dave wrote: On Linux... How can I execute a sql command against a sqlite DB straight from the command line. Somethign like sqlite3 foo.sqldb -e "select * from mytable" or... sqlite3 foo.sqldb < "select * from mytable" Dave, Write a script. If there'

[sqlite] executing sql on a sqlite from the cmd line

On Linux... How can I execute a sql command against a sqlite DB straight from the command line. Somethign like sqlite3 foo.sqldb -e "select * from mytable" or... sqlite3 foo.sqldb < "select * from mytable" (only these don't work) Also, can I prefix with a setup option (li