>From the SQLite shell .read myfile
Or, from the OS command shell sqlite3 foo.db ".read myfile" .help in the SQLite shell will give you the available commands Note. For me, it's a habit to end lines in the SQLite shell with a semicolon. That breaks the .read and .import commands because the SQLite shell includes the trailing semicolon as part of the file or table identifier. -Clark ----- Original Message ---- From: John Salerno <[EMAIL PROTECTED]> To: sqlite-users@sqlite.org Sent: Wednesday, August 23, 2006 1:01:46 PM Subject: Re: [sqlite] running a script? I'm asking about an actual file, though, not just a single query. I've tried something like what you suggest with the file path, but it doesn't work. On 8/23/06, Scott Baker <[EMAIL PROTECTED]> wrote: > echo "SELECT * FROM Table" | sqlite database.bin > > John Salerno wrote: > > Hi everyone. Can someone tell me the proper syntax for running a sql > > script when starting up sqlite from the command line interface? > > > > Thanks, > > John > > > > ----------------------------------------------------------------------------- > > > > To unsubscribe, send email to [EMAIL PROTECTED] > > ----------------------------------------------------------------------------- > > > > > > > > > > -- > Scott Baker - RHCE > Canby Telcom System Administrator > 503.266.8253 > > ----------------------------------------------------------------------------- > To unsubscribe, send email to [EMAIL PROTECTED] > ----------------------------------------------------------------------------- > > ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] ----------------------------------------------------------------------------- ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
