On Sun, 20 Aug 2006, John Salerno wrote:
> Hi everyone. I'm just getting started with sqlite and I was testing it
> on the command line. Is there a way to switch between databases while
> at the sqlite command prompt, or must you start the command prompt
> with a database? For example, must you always type:
>
> $ sqlite3 <name>
>
> or is there some kind of 'switch' type of statement to choose a
> different database to work on once you've entered the sqlite command
> line?
>
> Thanks!
> John
>
> -----------------------------------------------------------------------------
> To unsubscribe, send email to [EMAIL PROTECTED]
> -----------------------------------------------------------------------------
The attach command (and Gooble) is your friend ...
http://souptonuts.sourceforge.net/readme_sqlite_tutorial.html
NB: The ATTACH Command: Build a Virtual Table that Spans Multiple Tables
on Separate Databases ...
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
