> -----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] -----------------------------------------------------------------------------
