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 (like ".model column")? ... sqlite3 foo.sqldb -e ".model column; select * from mytable" Thanks in Advance for any advise -dave
