Yes, the sql works. (Thanks James) But how can I ".mode column" and ".header on" as well as run the query (given that I'm developing this for others to use and don't want to make them create/edit a ~/sqlite.init with those elements)
-dave -----Original Message----- 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, 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 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) sqlite3 foo.sqldb "select * from mytable" works for me on various platforms. (I tend to use single quotes in practice.) -- James ------------------------------------------------------------------------ ----- To unsubscribe, send email to [EMAIL PROTECTED] ------------------------------------------------------------------------ ----- ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
